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:00, 22 January 2007 (related this topic to another topic i.e. Expression (programming)). 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 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=102430058"