Condition (SQL)

A relational database management system uses SQL conditions or Expression (programming) in WHERE clauses and in HAVING clauses to SELECT subsets of data.

Examples

To SELECT one row of data from a table tab with primary key column pk set to 100 — use the condition pk = 100:

SELECT * FROM tab WHERE pk = 100

To SELECT the duplicate rows of data from a table tab with duplicate key column dk set to 100 — use the condition dk = 100 and the condition having count(*) > 1:

SELECT * FROM tab WHERE dk = 100 having count(*) > 1