Oracle 多表分页查询rownum

 Oracle 多表分页查询rownum

--------------------------------

select * from
 (
 select t0.ne_id,
        t0.ne_name,
        t1.msc_ave_load,
        t1.msc_max_load,
        t1.tone_bhca,
        t1.msc_bhca,
        t1.msc_load,
        t2.add_p_ms,
        rownum nu
   from nettest t0, perf_msc t1, perf_quality t2
  where t0.ne_id = t1.ne_id
    and t0.ne_id = t2.ne_id
    and rownum <= 5 )
    where nu >1

 

转载于:https://www.cnblogs.com/sky100/archive/2008/09/09/1287351.html