SQL Tutorial : DRL / DQL - COMPARISON & OPERATORS

SQL Tutorial : DRL / DQL - COMPARISON & OPERATORS

Let's learn about next topic: COMPARISON & OPERATORS

COMPARISON CONDITIONS:

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

- BETWEEN AND

- LIKE

- IN

- IS NULL

LOGICAL OPERATORS:

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

- NOT

- AND

- OR

- EXPONENTIAL
- ARITHMETIC OPERATOR
- COMPARISON OPERATORS
- COMPARISON CONDITIONS  NOT ( LIKE , IN , IS NULL)

- {NOT} BETWEEN

- NOT

- AND
- OR

- SELECT LAST_NAME,SALARY

FROM EMPLOYEES
WHERE SALARY >=10000 AND SALARY <=17000

- SELECT LAST_NAME,SALARY

FROM EMPLOYEES
WHERE SALARY BETWEEN 10000 AND 17000

- SELECT LAST_NAME,SALARY ,DEPARTMENT_ID

FROM EMPLOYEES
WHERE DEPARTMENT_ID =20 OR DEPARTMENT_ID=40

- SELECT LAST_NAME,SALARY ,DEPARTMENT_ID

FROM EMPLOYEES
WHERE DEPARTMENT_ID IN (20 ,40)

LIKE OPERATOR:

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

- CHARACTER MATCH OR WILDCARD SEARCH

%  => ZERO OR MORE CHARACTERS
_ => SINGLE CHARACTER

- SELECT LAST_NAME,SALARY

FROM EMPLOYEES
WHERE LAST_NAME LIKE 'K%'

- SELECT LAST_NAME,SALARY

FROM EMPLOYEES
WHERE LAST_NAME LIKE '%s%'

- SELECT LAST_NAME,SALARY

FROM EMPLOYEES
WHERE LAST_NAME LIKE '%r'

- SELECT LAST_NAME,SALARY

FROM EMPLOYEES
WHERE LAST_NAME LIKE '__c%'

IS NULL:

*********

SELECT LAST_NAME,JOB_ID,COMMISSION_PCT

FROM EMPLOYEES
WHERE COMMISSION_PCT IS NULL

IS NOT NULL:

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

SELECT LAST_NAME,JOB_ID,COMMISSION_PCT

FROM EMPLOYEES

WHERE COMMISSION_PCT IS NOT NULL

OR:

*********

SELECT EMPLOYEE_ID,LAST_NAME,JOB_ID,SALARY

FROM EMPLOYEES

WHERE( JOB_ID='SA_REP' OR JOB_ID='SA_MAN')

AND SALARY >10000