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);
----- ---------- --------- ----- ----------- --------- --------- ------
