34,593
社区成员
发帖
与我相关
我的任务
分享
select emp.*,dept.* from emp inner join
(
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
on emp.rowid = tt.rowid1
inner join dept on dept.rowid = tt.rowid2
and emp.deptno = dept.deptno
select m.* from
(
select emp.rowid emp_rowid , emp.其他字段 , dept.rowid dept_rowid dept.其他字段 from emp inner join dept on emp.deptno = dept.deptno
) m
inner join
(
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
) n
on m.rowid = n.rowid1 and m.rowid = n.rowid2
where n.rownum_ >= 4
select emp.*,dept.* from emp inner join dept on emp.deptno = dept.deptno
inner join
(
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 on dept.rowid = tt.rowid2
and emp.rowid = tt.rowid1
select emp.*,dept.* from emp inner join
(
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 on
emp.rowid = tt.rowid1 inner join
dept on emp.deptno = dept.deptno
select emp.*,dept.* from emp inner join dept on emp.deptno = dept.deptno where rownum <= 6 and rownum_ >= 4
select m.* from
(
select emp.rowid emp_rowid , emp.其他字段 , dept.rowid dept_rowid ,dept.其他字段 from emp inner join dept on emp.deptno = dept.deptno
) m
inner join
(
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
) n
on m.emp_rowid = n.rowid1 and m.dept_rowid = n.rowid2
where n.rownum_ >= 4