Posted by klabu on 11/12/06 22:00

>
> SELECT * FROM sometable
> WHERE rec_id, rec_sequence
> IN (SELECT rec_id, MAX( rec_sequence) FROM alppremh GROUP BY rec_id)
>
> thanks
>

edit:

SELECT * FROM sometable
WHERE rec_id, rec_sequence
IN (SELECT rec_id, MAX( rec_sequence) FROM alppremh GROUP BY rec_id)
and rec_id = 4883493

• Next in forum: Re: T-SQL Question
• Prev in forum: T-SQL Question
• Thread view: Re: T-SQL Question

[Reply to this message]