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条数据。