Re: Problem with SQL query :(
Posted by:
Rick James
Date: January 19, 2014 12:33PM
First, let's get on the same page for punctuation terminology:
[] - brackets (or "square brackets")
{} - braces (or "curly brackets")
<> - angle brackets
() - parentheses -- but not "brackets"
x AND y OR z is the same as (x AND y) OR z
x OR y AND z is the same as x OR (y AND z)
That is, without parentheses, AND has precedence over OR. If in doubt, add parens.
Your second example probably needed more parens.
Subject
Written By
Posted
Re: Problem with SQL query :(
January 19, 2014 12:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.