各种数据库分页

Oracle数据库分页：

select * 

from

(

select a.*,rownum as rownum_

from

(

实际查询的sql语句.

) a

where rownum<=maxnum

) b

where rownum_>= minnum

 

sqlserver数据库分页：

select a.*

from

(

select *,row_number() over (order by column_name) as rownum from table_name

) a

where a.rownum between minnum and maxnum

 

OR

 

select *

from

(
select top 页面容量 *

        from

        (
         select top 页面容量*当前页码 *

                from table_name

                where condition

                order by column_name  //升序
        ) as temp_table1

        order by column_name desc //注意是desc,即降序

) as temp_table2

order by column  //升序

 

mysql数据库分页：

select * from table_name order by column_name limit minnum-1,maxnum-minnum+1

注：

limit num; //前num行,等价于limit 0,num

limit num,-1; //第num+1行到最后