Jump to content

Condition (SQL)

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Xaje (talk | contribs) at 23:13, 10 March 2006. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

A relational database management system uses SQL conditions 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=43210529"