--mssqlserver的分页查询语句:
select top 10 * from t where id not in (select top 20 id from t order by id ) order by id ;
--或者
select top 10 * from t where id in (select top 20 id from t order by id) order by id desc ;
--mysql的分页查询语句:
select * from t order by id limit 20,10 从第20条开始检索10条数据;
--oracle的分页查询语句:
select * from (select rownum r,* from t where r<=30) where r>20;
数据库的分页查询
最新推荐文章于 2023-02-06 15:53:57 发布