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?

[Back to original message]