Soluções dos exercícios sobre o comando SELECT

1.

select *
from salgrade;

2.

select *
from emp;

3.

select *
from emp
where sal between 1000 and 2000;

select *
from emp
where sal>1000 and sal<2000;

4.

select deptno, dname
from dept
order by dname;

5.

select distinct job
from emp;

6.

select empno,ename,job,mgr,hiredate,sal,comm,deptno
from emp
where deptno in (10,20)
order by ename;

7.

select ename,job
from emp
where job='CLERK'
and deptno=20;

8.

select ename
from emp
where ename like '%TH%'
or ename like '%LL%'

9.

select ename,job,sal
from emp
where mgr is not null;

10.

select ename,sal*12+nvl(comm,0) Remuneração
from emp;

11.

select ename,deptno,hiredate
from emp
where to_char(hiredate,'YYYY') = ('1983');

12.

select ename,sal*12 Sal_anual, comm
from emp
where sal > comm
and job='SALESMAN'

Topo

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