-- Oracle method 1SELECT * FROM (SELECTA. *, ROWNUMRNFROM (SELECT * FROMss_custinfo) AWHEREROWNUMlt; 40) WHERERNgt;
-- Oracle method 1 SELECT * FROM (select a. *, rownum rn from (SELECT * FROM ss_custinfo) awhere rownum lt; = 40) where rn gt; =
-- Oracle method 1
SELECT * FROM
(
Select a. *, rownum rn from (SELECT * FROM ss_custinfo)
Where rownum <= 40
)
Where rn> = 21;
-- Oracle method 2
SELECT * FROM
(
Select ss. *, rownum rn from ss_custinfo ss
)
WHERE rn <= 40 and rn> = 21;
-- Oracle method 3
SELECT * FROM
(
Select a. *, ROWNUM RN
FROM (SELECT * FROM ss_custinfo)
)
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;
,