First page Back Continue Last page Image

Logical Operators Also Have Precedence

If more than one Logic Operator is used in the Same SQL Sequence, the (uncontrolled) Precedence is...

First NOT

Second AND

Third OR

As with the Arithmetic Operators all you need to do to Control the order is to use Parentheses

AND

OR

NOT

Condition 1

Condition 1

Condition 1

Condition 2

Condition 2