莫晓毅.txt

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

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

2 select job,sal from emp
  where sal=(select max(sal) from emp);

3 select ename from emp
    where sal=(select min(sal) from emp where job ='MANAGER') and job='MANAGER';

4 select deptno,job,avg(sal) from emp
  group by deptno,job
  having deptno=30 and avg(sal)>= (select avg(sal) from emp);

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

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