var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: limiting the range of select result
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 ?
you 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.