2016 03 19 dml

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

SELECT employee_id FROM HR.EMPLOYEES WHERE SALARY BETWEEN 1000 AND 2000;
select department_id, department_name from hr.departments order by department_name;
select job_title from hr.jobs;
select * from hr.employees where department_id = 10 or department_id = 20 order by first_name;
select first_name, job_id from hr.employees where department_id = 20 and job_id = 'ST_CLERK';
SELECT FIRST_NAME FROM HR.EMPLOYEES WHERE first_NAME LIKE '%th%' or first_name like '%ll%';
select first_name,job_id from hr.employees where manager_id is not null;
select first_name, salary*14+commission_pct from hr.employees;
select * from HR.employees where hire_date BETWEEN '01/01/83' AND '31/12/83';
select first_name, salary*14,commission_pct from hr.employees where job_id = 'ST_MAN';