Question

Which statement is correct about AND and OR operators used together in a WHERE clause?

Cosmo · Accepted Answer

AND operator has higher priority compared to OR operator.
For example,

WHERE condition_1 AND condition_2 OR condition_3

is equivalent to the following

WHERE (condition_1 AND condition_2) OR condition_3

Cosmo · Accepted Answer

AND has a higher priority over OR

Cosmo · Answer

Error wil be returned

Cosmo · Answer

OR has a higher priority over AND

Cosmo · Answer

Brackets should be obligatory used to separate conditions one from another