Operators are the
symbols used to perform some specific operations.
The different operators are:
• Arithmetic
Operators ( +, - , * , / )
• Relational
Operators ( > , < , >= , <= , = , < > or != - not
equals to )
• Logical
Operators ( NOT, AND, OR )
• Special
Operators ( IN , LIKE , BETWEEN , IS )
Rules for precedence
|
Order Evaluated
|
Operator
|
|
1
|
Arithmetic Operator
|
|
2
|
Concatenation
|
|
3
|
Comparison
|
|
4
|
Is, Like, In
|
|
5
|
Between
|
|
6
|
Not
|
|
7
|
AND
|
|
8
|
OR
|
