pageNow :第几页
pageSize :每页显示条数
Oracle分页查询sql:
select * from(select rownum rm, t.* from t_user t) tr where rm > 10 and rm <= 20//rownum :伪列
Oracle分页查询java代码:
select * from(select rownum rm, t.* from t_user t) tr where rm > pageSize * ( pageNow - 1 ) and rm <= pageSize * pageNow
MySQL分页查询sql:
select * from t_user limit 0, 3;//0:偏移量(第几条数据开始),3:每页显示条数MySQL
MySQL分页查询java代码:
select * from t_user limit pageSize * ( pageNow - 1 ),pageSize ;
sqlserver分页(没用过sqlserver,暂时先来个链接吧,也不知道对不对,但是用top好像是没错的):