CONDITIONAL SELECTIONS AND OPERATORS

We have two clauses used in this

Ø  Where

Ø  Order by

USING WHERE

Syntax:

     select * from <table_name> where <condition>;

    

the following are the different types of operators used in where clause.

v  Arithmetic operators         

v  Comparison operators

v  Logical operators

v  Arithmetic operators          -- highest precedence

+, -, *, /

v  Comparison operators

Ø  =, !=, >, <, >=, <=, <>

Ø  between, not between

Ø  in, not in

Ø  null, not null

Ø  like

v       Logical operators

Ø  And

Ø  Or                                -- lowest precedence

Ø  not