问一下下面这两种Oracle分页哪种写法是对的

[kroda]

select emp.*,dept.* from emp,dept,
 (
 select newrowid   
          from (select res.*, rownum rownum_   
                  from (select t.rowid newrowid from emp t) res   
                 where rownum <= 6) 
                 where rownum_ >= 4                 
                 )  tt               
where emp.rowid = tt.newrowid 
  and emp.deptno = dept.deptno   

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

 select emp.*,dept.* from emp,dept,
 (
 select rowid1,rowid2            from (select res.*, rownum rownum_   
                  from (select emp.rowid rowid1,dept.rowid rowid2 from emp,dept where emp.deptno = dept.deptno) res   
                 where rownum <= 6) 
                 where rownum_ >= 4                 
                 )  tt               
where emp.rowid = tt.rowid1
  and dept.rowid = tt.rowid2 
  and emp.deptno = dept.deptno  

另外 要求写成inner join版的 怎么写

[jtaocs]

分页只能这么写啊
要么用存贮过程吗

[asdf_ndsc]

都是能用的。就是很差。你们没 dba ?

select *
from (select emp.*, dept.* rownum rownum_
from emp, dept
where emp.deptno = dept.deptno
and rownum <= 6)
where rownum_ >= 4

[kroda]

你为何不用rowid呢 rowid是物理地址呀

[cab1225]

都可以哦、！！！！