Posted by metaperl on 12/31/07 18:50

If I do

SELECT TOP 25 * FROM table ORDER BY id

does it select any 25 records and then order them

or does it SELECT all the records, order them by ID then return the
first 25?

I'm guessing the former (based on some comparative SELECTs) and think
I need to do this:

SELECT TOP 25
(SELECT * FROM table ORDER BY id)

to get what I want.

• Next in forum: Re: SELECT TOP * ORDER BY question
• Prev in forum: database optimization
• Thread view: SELECT TOP * ORDER BY question

[Reply to this message]