Jump to content

Condition (SQL)

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 213.156.52.112 (talk) at 20:24, 2 August 2006. 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 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