For direct queries all
Select * from
The employee emp join
Dept d on emp. The deptno=d.d eptno
The join position pos on emp. Posid=pos. Posid
Join the employee MGR on emp. Mgrid=MGR. Empid


Could you tell me how to write page?

CodePudding user response:

The select... The from
(
Select rownum rn, emp. *, d., pos. *, * MGR. * from
The employee emp join
Dept d on emp. The deptno=d.d eptno
The join position pos on emp. Posid=pos. Posid
Join the employee MGR on emp. Mgrid=MGR. Empid
)
Where rn> 10 and rn<=20;

CodePudding user response:

reference 1st floor lhdz_bj response:

select... The from
(
Select rownum rn, emp. *, d., pos. *, * MGR. * from
The employee emp join
Dept d on emp. The deptno=d.d eptno
The join position pos on emp. Posid=pos. Posid
Join the employee MGR on emp. Mgrid=MGR. Empid
)
Where rn> 10 and rn<=20;

. How to fill in? Always prompt I not clearly defined

CodePudding user response:

The ellipsis "... "With your own names,