你这语句写的嵌套写的有何用。
试试select a1.*
from ( select id,title,sort,updt
from news
where sort = 1111
order by updt desc) a1 where rownum <10
试试select a1.*
from ( select id,title,sort,updt
from news
where sort = 1111
order by updt desc) a1 where rownum <10
from (select rownum rsn,a1.*
from ( select id,title,sort,updt
from news
where sort = 1111
order by updt desc) a1
) a2
where a2.rsn > 10 and a2.rsn < 20
第二页也不该这样写,效率很慢
你那种方法是把> 和<都放最外面。你试试这个
select a1.*
from ( select id,title,sort,updt ,rownum rn
from news
where sort = 1111
and rownum<20
order by updt desc) a1 where rn>=10
from (select rownum rsn, a1.*
from (select id,title,sort,updt
from base_student
where sort = 1111
order by updt desc) a1
where rownum <= 20) a2
where a2.rsn > 10
我创建索引的语句 是
create index i_base_student_updat on base_student(updt)
没有加其他参数
FROM (
SELECT id,title,sort,updt, to_number() orver (ORDER BY updt DESC) rsn
FROM news
WHERE sort = 1111
) a2
WHERE a2.rsn > 10 AND a2.rsn < 20
SELECT a2.*
FROM (
SELECT id,title,sort,updt, ROW_NUMBER() over (ORDER BY updt DESC) rsn
FROM news
WHERE sort = 1111
) a2
WHERE a2.rsn > 10 AND a2.rsn < 20