Jump to content

Condition (SQL)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Wwmbes (talk | contribs) at 14:05, 22 January 2007. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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
Retrieved from "https://en.wikipedia.org/w/index.php?title=Condition_(SQL)&oldid=102430845"