SQL Logic Operator Precedence: And and Or
Are the two statements below equivalent? SELECT […] FROM […] WHERE some_col in (1,2,3,4,5) AND some_other_expr and SELECT […] FROM […] WHERE some_col in (1,2,3) or some_col in (4,5) AND some_other_expr Is there some sort of truth table I could use to verify this? 4 Answers 4