各种DBMS的分页语句

mysql
select * from table limit m,n

 

oracle
select * from
(
 select row_.*,rownum rownum_from
 (
 select * from table
 )row_
)where rownum_<=m+n and rownum_>m-1

 

DB2
select * from
(
 select rownumber() over (...) as rownumber_,row_.* from
 (
 select * from table
 )as row_
)as temp_ where rownumber_<=m+n and rownumber_>m-1

 

FireBird
select * from table first m skip n

 

sql server
top 只可以获取当前若干条记录，不支持直接从中间区域进行获取，只好想办法利用minus等方法来取得。
select top m+n * from table
minus
select top m* from table