Practica No 1
--1. apellidos de los empleados que ganan mas de 12000
select last_name, salary
from employees
where salary > 12000;
--2. Muestra apellidos y departamentos de los empleados que sean con codigo igual a 176
select last_name, department_id
from employees
where employee_id = 176;
--3
select last_name, salary
from employees
where salary <= 5000 or salary >= 12000;
where salary not between 5000 and 12000;
-- 4.
select last_name, job_id, hire_date
from employees
where hire_date between ’20/02/98’ and ’01/03/98’
order by hire_date;
--Fecha actual
select sysdate from dual;
-- 5.
select last_name as nombre , department_id as plata
from employees
where department_id in (20,50)
order by first_name;
-- 6.
select last_name as nombre , salary as plata
from employees
where (salary <= 5000 or salary >= 12000) and (department_id in (20,50));
-- 7.
select last_name, hire_date
from employees
where hire_date LIKE ’%94’;
-- 8.
select last_name, job_id
from employees
where manager_id is null;
--- 9.
select last_name, salary , commission_pct
from employees
where commission_pct is not null
order by salary desc , commission_pct desc;
--1 0.
select first_name, last_name, salary , commission_pct
from employees
where last_name like ’__a%’;
-- 11.
select last_name, salary , commission_pct
from employees
where last_name like ’%a%’ and last_name like ’__e%’;
- 12.
select last_name, job_id, salary
from employees
where job_id IN (’ST_CLERK’,’SA_REP’) and salary not in (2500, 3500, 7000) ;
-13
select commission_pct, last_name as nombre , salary as plata
from employees
where commission_pct = 0.2;
2 comentarios
Natalia -
Alex -