SELECT emp.empno, emp.ename, emp.job, emp.mgr, emp.hiredate, emp.sal,
NVL (emp.comm, 0) comm, emp.deptno
FROM emp JOIN (SELECT deptno, MIN (empno) minempno
FROM emp
GROUP BY deptno) emp1 ON emp.empno = emp1.minempno
NVL (emp.comm, 0) comm, emp.deptno
FROM emp JOIN (SELECT deptno, MIN (empno) minempno
FROM emp
GROUP BY deptno) emp1 ON emp.empno = emp1.minempno
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货