SQL Tutorial : DRL / DQL - WHERE CLAUSE

SQL Tutorial : DRL / DQL - WHERE CLAUSE

Let's learn about next topic: WHERE CLAUSE

WHERE CLAUSE:

***************

- FILTERS THE SELECTION FROM SAME TABLE OR FROM DIFFERENT TABLE USING JOIN

- WHERE CLAUSE => COLUMNS , OPERATORS , CONSTANTS

eg:

- SELECT EMPLOYEE_ID,LAST_NAME,SALARY
FROM EMPLOYEES
WHERE EMPLOYEE_ID=100

- SELECT EMPLOYEE_ID,LAST_NAME,SALARY,DEPARTMENT_ID

FROM EMPLOYEES
WHERE DEPARTMENT_ID=20

- SELECT EMPLOYEE_ID,LAST_NAME,SALARY ,HIRE_DATE

FROM EMPLOYEES
WHERE HIRE_DATE >'01-JAN-1998'

- SELECT EMPLOYEE_ID,LAST_NAME,SALARY ,HIRE_DATE

FROM EMPLOYEES
WHERE HIRE_DATE ='07-FEB-1999'