dbms all command.txt

SELECT EMPLOYEE_ID,FIRST_NAME ,SALARY*12
FROM employees;
SELECT EMPLOYEE_ID,FIRST_NAME ,SALARY*12 AS 'yearly salary'
FROM employees;
SELECT EMPLOYEE_ID,FIRST_NAME ,SALARY*12 AS 'yearly salary'
FROM employees
ORDER BY SALARY DESC ,FIRST_NAME;
SELECT EMPLOYEE_ID,FIRST_NAME ,SALARY*12 AS 'yearly salary'
FROM employees
ORDER BY SALARY DESC ,FIRST_NAME
LIMIT 2,1;
SELECT EMPLOYEE_ID,FIRST_NAME ,SALARY
FROM employees
WHERE SALARY>20000;


SELECT EMPLOYEE_ID,FIRST_NAME ,HIRE_DATE
FROM employees
/*WHERE HIRE_DATE>='1997-12-1' AND HIRE_DATE<='1997-12-31'; */
WHERE HIRE_DATE BETWEEN '1997-12-1' AND HIRE_DATE<='1997-12-31';

#IN

SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
/*WHERE DEPARTMENT_ID=10 || DEPARTMENT_ID=50 || DEPARTMENT_ID=50 */
WHERE DEPARTMENT_ID IN(10,50,60);

#IS

SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees
/*WHERE DEPARTMENT_ID=10 || DEPARTMENT_ID=50 || DEPARTMENT_ID=50 */
WHERE DEPARTMENT_ID IN(10,50,60) IS FALSE;

# LIKE

SELECT EMPLOYEE_ID, FIRST_NAME, HIRE_DATE, DEPARTMENT_ID
FROM employees

WHERE FIRST_NAME LIKE "L%"; # Start with L

# CASE WHEN

SELECT EMPLOYEE_ID, 
           CASE WHEN SALARY>20000 THEN 'A'
           WHEN SALARY BETWEEN 10000 AND 20000 THEN 'B'
           ELSE 'C' END
           
           AS "SALARY GRADE"
           
           FROM employees;

# NULL

SELECT EMPLOYEE_ID, SALARY+SALARY*COMMISSION_PCT AS 'total sal'
FROM employees

NEXT ONLINE 4.1- 4.7, SLIDE page 11