mysql查询31到40条_Oralce分页－查询21到40条的数据

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

--Oracle方法1

SELECT * FROM

(

SELECT A.*, ROWNUM RN FROM (SELECT * FROM ss_custinfo) A

WHERE ROWNUM <= 40

)

WHERE RN >= 21;

--Oracle方法2

SELECT * FROM

(

select ss.*, rownum rn from ss_custinfo ss

)

WHERE rn <= 40 and rn>= 21;

--Oracle方法3

SELECT * FROM

(

SELECT A.*, ROWNUM RN

FROM (SELECT * FROM ss_custinfo) A

)

WHERE RN BETWEEN 21 AND 40;

--sybase

select * from

(

select ss.*, row_number() over (order by cust_id desc ) as rn

from ss_custinfo ss

) temp

where 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

) temp

where temp.rn<=40 and temp.rn>=21;

，

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网