分页查询，各个数据库不同的实现方式
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 ANDT_PAGINATION_SUMMY.ROWNUMBER > 10
MYSQL 第10条后的10条数据
select * from systemparameter limit 10,10;
以上都是取第11条到第20条数据。
页:
[1]