AND OR precedence

[filure]

Hello,

in the query :

SELECT ...
FROM ...
WHERE X
AND
Y
OR
Z

How is evaluated the filter?

(X AND Y) OR Z ?
X AND (Y OR Z) ?

What is the precedence?

Thank u.

 

[jgerstb]

I believe it is AND first and then OR. But I would use parens to make it clear to anyone reading the code what conditions should be ORed

 

[rrrkrishnan]

It will be interpreted as (X AND Y) OR Z.