Posted by rcamarda on 05/18/06 23:21

Untested

SELECT
MAX(FD_ID) AS 'FD_ID',
FD_USER,
MAX(FD_EFFECTIVE) AS 'FD_EFFECTIVE'
FROM F_TABLE
GROUP FD_USER

• Next in forum: Re: Conditions on latest record
• Prev in forum: Conditions on latest record
• Thread view: Re: Conditions on latest record

[Reply to this message]