直接查詢所有的話
select * from
employee emp join
dept d on emp.deptno = d.deptno
join position pos on emp.posid = pos.posid
join employee mgr on emp.mgrid = mgr.empid
請問如何寫成分頁的呢？
uj5u.com熱心網友回復：
select ... from
(
select rownum rn,emp.*,d.*,pos.*,mgr.* from
employee emp join
dept d on emp.deptno = d.deptno
join position pos on emp.posid = pos.posid
join employee mgr on emp.mgrid = mgr.empid
)
where rn>10 and rn<=20;
uj5u.com熱心網友回復：
... 該怎么填？一直提示我未明確定義列
uj5u.com熱心網友回復：
把省略號“...”換成你自己的列名。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/13065.html
標籤：基礎和管理