Baixe o app para aproveitar ainda mais
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;
Compartilhar