LIMIT with mysql ...

[Anon]

hi
i used LIMIT clause with many queries in mysql database. but anyone can tell plz that is there any other way to use limit or (LIMIT like thing) with MS Access or MS SQL SERVER ???
plz answer
thanks
shahid

[ugh82]

I think that Ms access and sql has only the TOP clause.

For example
"select id,news,dt order by dt desc TOP 5"
exports the top 5 rows matching your query.

=)

[Anon]

This would probably work:

MySQL:
SELECT field FROM table ORDER BY id LIMIT 300, 20

MSSQL:
SELECT field FROM (SELECT TOP 20 field FROM (SELECT TOP 320 field FROM table ORDER BY id) AS t1 ORDER BY id DESC) AS t2 ORDER BY id