select emp.deptno,dept.dname,emp.sal from dept,emp where emp.sal<5000 and emp.deptno = dept.deptno
应该差不多了，我没试，你试试看吧，不对的话我再给你想想
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
SELECT DEPTNO,DNAME,MIN(SAL)
FROM DEPT A JOIN EMP ON A.DEPTNO = B.DEPTNO
WHERE SAL >= 5000
GROUP BY DEPTNO,DNAME
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024