李强.txt

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

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

2)
select  max(sal),max(job)
from emp                                     



3)
select ename  from emp
where sal = (select MIN(sal) from emp where job = 'MANAGER' ) 



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




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


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