Condition (SQL)

From Wikipedia, the free encyclopedia

You have new messages (last change).

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

[edit] 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
Retrieved from "http://en.wikipedia.org../../../c/o/n/Condition_%28SQL%29_5da8.html"