oralce分页－查询21到40条的数据

--Oracle方法1SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM ss_custinfo) AWHERE ROWNUM <= 40)WHERE RN >= 21;

--Oracle方法2SELECT * FROM (select ss.*, rownum rn from ss_custinfo ss)WHERE rn <= 40 and rn>= 21; 

--Oracle方法3SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM ss_custinfo) A )WHERE RN BETWEEN 21 AND 40;

--sybaseselect * from (select ss.*, row_number() over (order by cust_id desc ) as rnfrom ss_custinfo ss) tempwhere temp.rn<=40 and temp.rn>=21;

select * from (SELECT ss.*, row_number() OVER (partition by cust_id ORDER BY salary desc) rn FROM ss_custinfo ss) tempwhere temp.rn<=40 and temp.rn>=21;