各种DBMS的分页语句
mysqlselect * 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
页:
[1]