2016 03 15 Aula 05 Comandos DML Select

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

SELECT * FROM HR.EMPLOYEES;
SELECT FIRST_NAME, LAST_NAME, SALARY FROM HR.EMPLOYEES;
SELECT FIRST_NAME "PRIMEIRO NOME",
 SALARY "SALÁRIO", 
 (SALARY * 12)*0.45 "SALÁRIO ANUAL" FROM HR.EMPLOYEES;
 
SELECT * FROM HR.DEPARTMENTS; 
 
SELECT 'NOME: ' || FIRST_NAME FROM HR.EMPLOYEES;
SELECT FIRST_NAME || ' ' || LAST_NAME "NOME COMPLETO" FROM HR.EMPLOYEES;
SELECT DISTINCT DEPARTMENT_ID FROM HR.EMPLOYEES;
SELECT DISTINCT FIRST_NAME, LAST_NAME FROM HR.EMPLOYEES
SELECT * FROM HR.EMPLOYEES
WHERE DEPARTMENT_ID = 20;
SELECT * FROM HR.EMPLOYEES
WHERE DEPARTMENT_ID <> 90;
SELECT FIRST_NAME, LAST_NAME FROM HR.EMPLOYEES
WHERE HIRE_DATE > '31/12/01'
SELECT FIRST_NAME, LAST_NAME,HIRE_DATE FROM HR.EMPLOYEES
WHERE HIRE_DATE >= '01/01/01' AND HIRE_DATE <= '31/12/02';
SELECT FIRST_NAME, LAST_NAME,DEPARTMENT_ID FROM HR.EMPLOYEES
WHERE DEPARTMENT_ID BETWEEN 50 AND 90;
SELECT FIRST_NAME, LAST_NAME,DEPARTMENT_ID FROM HR.EMPLOYEES
WHERE HIRE_DATE BETWEEN '01/01/01' AND '31/12/02';
SELECT FIRST_NAME, LAST_NAME,DEPARTMENT_ID FROM HR.EMPLOYEES
WHERE department_id IN (10,50,100,90);
SELECT FIRST_NAME, LAST_NAME,DEPARTMENT_ID FROM HR.EMPLOYEES
WHERE LAST_NAME LIKE '%an%';
SELECT * FROM HR.EMPLOYEES
WHERE commission_pct IS NULL;
SELECT FIRST_NAME, LAST_NAME,DEPARTMENT_ID,HIRE_DATE FROM HR.EMPLOYEES
WHERE HIRE_DATE NOT BETWEEN '01/01/01' AND '31/12/02';
SELECT FIRST_NAME, LAST_NAME,DEPARTMENT_ID FROM HR.EMPLOYEES
WHERE department_id NOT IN (10,50,100,90);
SELECT FIRST_NAME, LAST_NAME,DEPARTMENT_ID FROM HR.EMPLOYEES
WHERE LAST_NAME NOT LIKE '%an%';
SELECT * FROM HR.EMPLOYEES
WHERE commission_pct IS NOT NULL;
SELECT	First_name, Last_name, Salary, Job_ID
FROM	hr.Employees
WHERE	Salary BETWEEN 2000 AND 3000
 and Job_id = 'ST_CLERK';
 
SELECT EMPLOYEE_ID,FIRST_NAME, LAST_NAME, SALARY, DEPARTMENT_ID
FROM HR.EMPLOYEES
ORDER BY FIRST_NAME,SALARY ASC;