首页 > 资讯 > DB2 > 正文

DB2,Oracle,SQLserver,Mysql分页查询语句

17-05-12        来源：[db:作者]  

收藏   我要投稿

db2:
select t1.* from (
	select t.*,rownumber() over(order by t.id ASC)) as rn from t_students t
) as t1 where t1.rn between (pageNum-1)*pageSize and pageNum*pageSize


Oracle:
select * from (
	select t.*,t.rownum from t_student t 
) where rownum>pageSize*(pageNum-1) and rownum<=pageSize*pageNum;

sql server:
select top pageSize t.* from t_students t
where t.id not in (
	select top (pageNum-1)*pageSize t1.id from t_students t1 order by t1.id
)order by t.id;

mysql:
select * from t_students t limt (pageNum-1)*pageSize,pageSize;

上一篇：CentOS6.8服务器LAMP环境搭建(四) 源码安装phpMyAdmin4.7.0

下一篇：初识mongodb----索引

• 用最简单的思路看SEOVIP的关键字选择
• Cacti图形数据自动导出脚本
• ps特效：photoshop中怎么快速绘制彩色的气泡效果？
• Win10怎么设置开机密码