1.采用limit关键字进行分页
select * from table order by id asc limit 100,20
2.使用top关键字
select top 20 * from table where id not in(select top 100 from table order by id asc)order by id
3.使用大于或者小于条件
select * from table where id > 100 order by id limit 20
1.采用limit关键字进行分页
select * from table order by id asc limit 100,20
2.使用top关键字
select top 20 * from table where id not in(select top 100 from table order by id asc)order by id
3.使用大于或者小于条件
select * from table where id > 100 order by id limit 20