你要序号? SELECT * FROM (select rownum rm,CallDutyApplication.* from CallDutyApplication ) where rm>12 and rm<= 24 order by CDA_applicatedate desc;
上面序号乱 select rownum rm,a.* from (select * from CallDutyApplication order by CDA_applicatedate desc) a where rm>12 and rm<= 24 ;
select * from (select CallDutyApplication.*, row_number() over(order by CDA_applicatedate desc) rk from CallDutyApplication ) where rk between 13 and 24
SELECT * FROM (select rownum rm,CallDutyApplication.* from CallDutyApplication ) where rm>12 and rm<= 24 order by CDA_applicatedate desc;
select rownum rm,a.* from (select * from CallDutyApplication order by CDA_applicatedate desc) a where rm>12 and rm<= 24 ;
from
(select CallDutyApplication.*,
row_number() over(order by CDA_applicatedate desc) rk
from CallDutyApplication )
where rk between 13 and 24