段湘南.txt

来自「关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品」· 文本 代码 · 共 29 行

select job,avg(sal) from emp group by job;

select job,sal from emp 
where sal > = all(select sal from emp);

select ename,sal from emp 
where job = 'MANAGER'
and
sal < = all(select sal from emp where job = 'MANAGER');

select distinct job,avg(sal) from emp
where deptno = 30
group by job
having avg(sal) > = all(select avg(sal) from emp where deptno=30 group by job)
;

select ename from emp
where ename like '%K%'
and
job = 'MANAGER';

select deptno,job,avg(sal) from emp
group by deptno,job;