Last updated: August 27, 2026.
Use AND when every condition must be true and OR when any condition may be true. Parentheses make mixed expressions unambiguous.
Syntax
SELECT column_list
FROM table_name
WHERE condition_a AND (condition_b OR condition_c);Example
SELECT EmployeeIDNo, Position, Salary
FROM EmployeeStatisticsTable
WHERE Position = 'Manager'
AND (Salary >= 60000 OR Commission > 0);SQL normally evaluates AND before OR, but explicit parentheses communicate the intended rule and prevent maintenance mistakes.
See the current PostgreSQL SQL reference; confirm dialect details for your own database.
