Condition (SQL): Difference between revisions

Revision as of 14:00, 22 January 2007

Revision as of 14:05, 22 January 2007

Line 1:

A [[relational database management system]] uses [[SQL]] '''conditions''' or [[Expression (programming)]] in '''<tt>WHERE</tt>''' clauses and in '''<tt>HAVING</tt>''' clauses to '''<tt>[[select (SQL)|SELECT]]</tt>''' subsets of data.

== Examples ==

Line 5:

To '''<tt>SELECT</tt>''' one row of data from a table ''tab'' with primary key column ''pk'' set to 100 &mdash; use the condition ''pk = 100'':

SELECT * FROM tab WHERE ''pk = 100''

[[Category:SQL]]