章彬.txt

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

1.SQL> select job,avg(sal) from emp
  2  group by job;

2.SQL> select job,sal from emp
  2  where sal = (select max(sal) from emp);
3.
SQL> select ename from emp
  2  where sal = (select min(sal) from emp where job ='MANAGER');
4.
   select deptno,job 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.SQL> select deptno,job,avg(sal) from emp
  2  group by rollup(deptno,job);