Soluções dos exercícios sobre funções de grupo

1.

select min(sal) from emp;

2.

select min(sal), max(sal), avg(sal) from emp;

3.

select job, max(sal), min(sal) from emp group by job;

4.

select count(*) from emp where job='MANAGER';

5.

select job, avg(sal), avg(sal*14+nvl(comm,0)) 
from emp
group by job;

6.

select max(sal)-min(sal) from emp;

7.

select deptno, count(*) 
from emp
group by deptno
having count(*) > 3;

8.

select empno 
from emp
group by empno
having count(*) > 1;

9.

select mgr, min(sal)
from emp
group by mgr
having min(sal)>=1000
order by min(sal);

Topo

Realizado por Turtle Learning ®. Última alteração em 2011-02-26