Oracle 学习日记:分组查询,子查询,复杂查询

今天依旧学习了Oracle的查询操作,内容是分组查询,子查询,复杂查询,下面将今天的部分代码贴到下边
–在where子句中使用子查询
select sal
from emp
where job = ‘MANAGER’;

select * from emp
where sal in (
select sal from emp where job = ‘MANAGER’);
–注意在固定的引号中的字段中不能有空格例如’MANAGER’不能写成’MANAGER ‘

select * from emp
where sal =any (
select sal from emp where job = ‘MANAGER’);

select * from emp
where sal >all (
select sal from emp where job = ‘MANAGER’);

select * from emp
where sal in (
select sal from emp where job = ‘MANAGER’);

select * from emp
where sal