常见数据库分页SQL语句-熔岩-51CTO技术博客-领先的IT技术博客

数据库分页语句使用：

1.Oracle:

 

select * from ( select row_.*, rownum rownum_ from ( query_SQL ) row_ where rownum =< max) where rownum_ >= min

2.SQL Server:

 

select top @pagesize * from tablename where id not in
(select top @pagesize*(@page-1) id
from tablename order by id) order by id

 

3.MySQL

 

select * from tablename limit position, counter

 

4.DB2

 

select * from (select *,rownumber() as ROW_NEXT from tablename) where ROW_NEXT between min and max

 

 

欢迎网友回帖补充！

出自 51CTO.COM博客