oracle数据库分页查询

ROWNUM是伪列，只能<=，不能>=
所以需要给ROWNUM起个别名，变成逻辑列后来比较

select *
from (select rownum as num,a.* from (select * from test order by 1 asc) a) t
where t.num>=20
and t.num<=40;

你写的可以修改为：
 

select *
from (select ROWNUM as num,A.* from (select * from test) A where rownum <= 40)
where num >= 20;