子查询的关键字
all any some in exists
use mydb3;
-- 查询年龄大于'1003'部门所有年龄的员工信息
select * from emp3 where age > all (select age from emp3 where dept_id = '1003');
-- 查询不属于任何一个部门的员工信息
select * from emp3 where dept_id != all (select deptno from dept3);
子查询的关键字
all any some in exists
use mydb3;
-- 查询年龄大于'1003'部门所有年龄的员工信息
select * from emp3 where age > all (select age from emp3 where dept_id = '1003');
-- 查询不属于任何一个部门的员工信息
select * from emp3 where dept_id != all (select deptno from dept3);