Question

有两张表，部门表DEPT字段为，DEPTNO,DNAME和雇员表EMP字段为，EMPNO,ENAME,JOB,MGR,SAL,DEPTNO.

列出雇员最低工资高于5000的部门号DEPTNO,部门名称DNAME最低工资SAL.

要求：效率越高越好，sql语句越简单越好，谢谢各位。

Answer 1

select emp.deptno,dept.dname,emp.sal from dept,emp where emp.sal<5000 and emp.deptno = dept.deptno
应该差不多了，我没试，你试试看吧，不对的话我再给你想想

Answer 2

SELECT a.DEPTNO,dname ,sal FROM DEPT a
LEFT JOIN (SELECT MIN (sal)sal ,deptno FROM EMP GROUP BY DEPTNO)b
ON b.DEPTNO = a.DEPTNO
where b.sal>5000

Answer 3

SELECT DEPTNO,DNAME,MIN(SAL)
FROM DEPT A JOIN EMP ON A.DEPTNO = B.DEPTNO
WHERE SAL >= 5000
GROUP BY DEPTNO,DNAME