Posted by Plamen Ratchev on 02/09/07 16:26

Yes, TOP is applied after the result set rows are ordered with ORDER BY.

Regards,

Plamen Ratchev
http://www.SQLStudio.com

• Next in forum: Re: Learning SQL Server with Win XP Home
• Prev in forum: Re: get record with earliest datetime value
• Thread view: Re: get record with earliest datetime value

[Reply to this message]