Posted by metaperl on 12/31/07 19:17

On Dec 31, 1:50 pm, metaperl <metap...@gmail.com> wrote:

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

actually the above is invalid syntax. how can I get MS-SQL to give me
the 25 records which have the lowest id instead of 25 random records
ordered by id?

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

[Reply to this message]