--SQL Server
select top 100 * from table
where id is not in(select top 100 id from table)
select r.*, row_number() over(order by id desc) as r from table where r>100 and r<=200

select * from  table limit 100,200;

select * from (select rownum r,t.* from table t) where r>100 and r<=200;

Leave a Reply

Your email address will not be published. Required fields are marked *