Databases Reference
In-Depth Information
Table 7-3: Operator Precedence
Level
Operators
1
~ (bitwise not, invert bit values)
2
* (multiplication)
/ (division)
% (modulo division)
3
(set numeric to positive)
(negate numeric value)
(add)
(subtract)
(concatenate)
& (bitwise AND comparison)
4
(equality comparison)
(greater than comparison)
(less than comparison)
(greater than or equal to comparison)
(less than or equal to comparison)
(or !
) (not equal to comparison)
!
(not greater than)
!
(not less than)
5
^ (bitwise exclusive OR comparison)
| (bitwise OR comparison)
6
NOT (negate logical value)
7
AND (logical AND comparison)
8
ALL (compare all values in a set)
ANY (compare for any value instance in a set)
BETWEEN (test for value in a range)
IN (test for value instance in a set)
LIKE (compare similar values based on literal text and wildcards)
SOME (test for one or more instance occurrences in a set)
9
(assign value)
