Last updated: August 27, 2026.
The WHERE clause filters rows before they are returned, grouped, updated, or deleted.
Syntax
SELECT column_list
FROM table_name
WHERE condition;Example
SELECT EmployeeIDNo, Salary
FROM EmployeeStatisticsTable
WHERE Position = 'Manager'
AND Salary > 50000;Use IS NULL rather than = NULL. In application code, pass user values through parameters instead of concatenating them into SQL.
See the current PostgreSQL SQL reference; confirm dialect details for your own database.
