Posted by klabu on 11/12/06 21:52

How to write an equivalent SQL like this (which works on Oracle):

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

thanks

• Next in forum: Re: T-SQL Question
• Prev in forum: Re: Actuarial sql statement Need Help.
• Thread view: T-SQL Question

[Reply to this message]