Banco De Dados - Exemplos Select

SQL> select nome_func, salario from funcionario where salario > 1800 order by salario desc;

NOME_FUNC SALARIO

---------------------------------------- ----------

Sergio Santos 2400

Jo„o da Silva 2000

SQL> select distinct salario, nome_func from funcionario order by salario asc;

SALARIO NOME_FUNC

---------- ----------------------------------------

1200 Mario Castro

1400 Marcio Santana

1500 Mario Souza

2000 Jo„o da Silva

2400 Sergio Santos

SQL> select nome_func, salario from funcionario where salario > 1500 and salario < 2400;

NOME_FUNC SALARIO

---------------------------------------- ----------

Jo„o da Silva 2000

SQL> select nome_func,salario from funcionario where (nome_func like '%Silva') order by salario desc;

NOME_FUNC SALARIO

---------------------------------------- ----------

Jo„o da Silva 2000

SQL> select distinct cod_func, horas_trab from func_proj where (cod_proj = 1001 and horas_trab > 50) or (cod_proj = 1003 and horas_trab > 60);

COD_FUNC HORAS_TRAB

---------- ----------

102 56

103 64

105 84

SQL> select avg (salario) as Media, max(salario) as maior, min(salario) as menor from funcionario;

MEDIA MAIOR MENOR

---------- ---------- ----------

1700 2400 1200

SQL> select avg (salario) as Media from funcionario where cod_depto = 2;

MEDIA

----------