1.
select employee_id, first_name
from employees
where upper(first_name) like '%R%';
2.
select employee_id, first_name, job_id, department_id
from employees
order by job_id, department_id ;
3.
select employee_id, first_name, job_id, comission_pct
from employees
where comission_pct is null;
4.
select first_name
from employees
where upper(first_name) like '_L%';
5.
select distinct job_id
from jobs;
6.1
select first_name, job_id
from employees
where department_id in (10,60);
6.2
select first_name, job_id
from employees
where department_id like 10 or department_id like 60;
7.
select first_name, comission_pct
from employees
where comission_pct > 0.3;
8.
select first_name, salary, department_id
from employees
where department_id=50
order by salary desc;
9.
select first_name
from employees
where first_name like '____';
10.
select first_name, job_id
from employees
where employee_id in (148,149)
order by first_name;
11.
select first_name, last_name, salary, job_id
from employees
where upper(first_name) like '%L%' and job_id like 'SA_REP' and salary >9600;
12.
select first_name, employee_id
from employees
where employee_id between 170 and 177;
Comments