1、列出至少有一个雇员的所有部门 select dname from dept where deptno in(select distinct deptno from emp) === 存在查询 SELECT * FROM dept d WHERE EXISTS( SELECT * FROM emp e WHERE e.deptno=d.deptno ) == SELECT * FROM dep... [阅读全文]