不排序:
select * from atable where rownum<=20;
排序:
select a.* from (select * from atable order by rol) a where rownum<=20;
select * from atable where rownum<=20;
排序:
select a.* from (select * from atable order by rol) a where rownum<=20;
例如表a, 主键k,有10000条记录
SELECT * FROM
( SELECT ROWNUM id,a.* FROM a where id<=200)
WHERE id >=181;
SELECT * FROM
( SELECT ROWNUM id,a.* FROM a where rownum<=200)
WHERE id >=181;
排序:
select * from (select rownum id,a.* from (select * from a order by k) a where rownum<=200)
where id>10;
select * from (select rownum id,a.* from (select * from a order by k) a where rownum<=200)
where id>=181;