Hi,
i'm searching how to tell to mysql server to limit
the range of a result select.
I would like to have the equivalent of the LIMIT clause in MYSQL.
I know there is TOP but it is not sufficient because it returns
only the first n lines.
I would like to tell sqlserver to begin at a certain offset.
Any idea ?
Thxyou can use a derived table
select top 10 *
from (select top 20 * from tbl order by id) as a
order by id desc
Will get the second 10 recs.
No comments:
Post a Comment