sql
Wednesday, July 25, 2018
10:28 AM
Methrod
.order_by('date')
SELECT column_name1, column_name2, etc
FROM table_name
WHERE salary > 10000
Condition = salary > 10000
Oracle SQL Developper : hr
WHERE last_name = 'King'  *Data when using like is case sensitive
WHERE condition1 AND (condition2 OR condition3)   *brackets 
WHERE first_name LIKE 'E%'       *Data when using like is case sensitive
WHERE (salary between 5000 and 1000) and (department_id between 50 and 80)
WHERE job_id in ('IT_PROG','AD_VP')
WHERE department_id in (90,100)
WHERE job_id not in ('IT_PROG','AD_VP')
select distinct department_id
from employees