sql-practice/2_WHERE.sql at master · BaekHanCheon/sql-practice · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
select
	first_name,
	last_name,
	job_id
from employees
where job_id = 'IT_PROG';

select
	*
	from  employees
	where last_name = 'King';

select
	*
from employees
where salary >= 15000
and salary <= 20000;

select
*
from employees
where hire_date = '1994-08-17';

select
*
from employees
where hire_date between '1994-01-01'and'1994-12-31';

select
*
from employees
where job_id  in ('IT_PROG','AD_VP','FI_MGR');


select
first_name, last_name ,hire_date
from employees
where first_name like '%t';

select
first_name, last_name ,hire_date
from employees
where to_char(hire_date, 'YY-MM-DD') like '94%';

select * from employees
where commission_pct is null;

select * from employees
where commission_pct is not null;


select * from employees
where job_id = 'IT_PROG'
or job_id = 'FI_MGR'
and salary >= 6000;

select * from employees
where (job_id = 'IT_PROG'
or job_id = 'FI_MGR')
and salary >= 6000;


select * from employees order by hire_date;


select
first_name, last_name ,job_id
from employees
where job_id = 'IT_PROG'
order by first_name desc;

select
	first_name,
	salary * 12 as 연봉
	from employees
	order by 연봉 desc;