数据库(exists与单行函数)
8.2.6exists
-查询销售部与会计部的员工信息
select *
from emp
where exists
(select * from dept where dname in('SALES','ACCOUNTING') and dept.deptno = emp.deptno);
select *
from emp e
where exists
(select * from dept d where dname in('SALES','ACCOUNTING') and d..
原创
2021-12-05 16:56:27 ·
97 阅读 ·
0 评论