分页查询，各个数据库不同的实现方式

Oracle下取10条到20条数据

 

SELECT T_PAGINATION_SUMMY.* FROM (SELECT ROWNUM ROWNUMBER,T_PAGINATION.*  FROM (
        SELECT * from systemparameter
) T_PAGINATION WHERE ROWNUM <= 20) T_PAGINATION_SUMMY WHERE T_PAGINATION_SUMMY.ROWNUMBER > 10

 

 

DB2下取10条到20条数据

 

        
SELECT T_PAGINATION_SUMMY.* FROM ( SELECT ROWNUMBER()OVER()AS ROWNUMBER,T_PAGINATION.* FROM (
       SELECT * from systemparameter
) AS T_PAGINATION ) AS T_PAGINATION_SUMMY WHERE T_PAGINATION_SUMMY.ROWNUMBER <= 20 AND  T_PAGINATION_SUMMY.ROWNUMBER > 10
        

 

MYSQL 第10条后的10条数据

 

  

select * from systemparameter limit 10,10;

 

以上都是取第11条到第20条数据。