oracle子查询(六)

select sal from emp where ename='JONES';

select * from emp where sal>2975;

select * from emp where sal>(select sal from emp where ename='JONES');

select * from emp where job=( select job from emp where empno=7876) and sal>( select sal from emp where empno=7521);

select * from emp where sal>(select avg(nvl(sal,0)) from emp);

select deptno,min(sal) from emp group by deptno having min(sal)>( select min(sal) from emp where deptno=20);

select * from emp where sal < any (select sal from emp where job='CLERK') and job<>'CLERK';

select * from emp where sal > all (select sal from emp where job='CLERK') and job<>'CLERK';

select * from emp where job in(select job from emp where deptno=10) and deptno<>10;

select * from emp where exists(select * from dept);

select * from emp where exists(select * from dept where deptno=80);

----- ---------- --------- ----- ----------- --------- --------- ------