论坛 › SQL Server › 各种数据库分页SQL

想你了的他他 发表于 2016-11-10 07:25:22

各种数据库分页SQL

　　1、Oracle

select * from (select e.*, rownum rn from (select * from test order by id) e where rownum <= 10) where rn >= 1;
　　
　　2、MySql

select * from test order by id desc limit 1,10;
　　
　　3、SQL Server

select top 10 * from test where id not in (select top 1 id from test order by id desc)order by id desc;
　　
　　4、DB2

select * from (select e.*,rownumber() over(order by id asc) as rowid from test e) as t where t.rowid>=1 and t.rowid<10
　　

查看完整版本: 各种数据库分页SQL