Oracle中没有limit,top等,需要嵌套查询来实现类似功能。
order by 与 rownum一起使用时,Oracle中需要三层查询实现:
select b.*
from (select rownum r, a.*
from (select b.* from nfs_gbl.batch_job b order by b.ref_no) a) b
where r >= 1
and r <= 2;
Oracle中没有limit,top等,需要嵌套查询来实现类似功能。
order by 与 rownum一起使用时,Oracle中需要三层查询实现:
select b.*
from (select rownum r, a.*
from (select b.* from nfs_gbl.batch_job b order by b.ref_no) a) b
where r >= 1
and r <= 2;