Condition (SQL): Difference between revisions

Revision as of 16:45, 26 August 2009

Revision as of 22:46, 16 December 2009

Line 1:

{{Unreferenced|date=December 2009}}

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.

{{Orphan|date=December 2009}}

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 ==

== Examples ==

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'':

Line 11 ⟶ 13:

SELECT * FROM tab WHERE ''dk = 100'' having count(*) > 1

{{DEFAULTSORT:Condition (Sql)}}

[[Category:SQL]]

[[Category:Articles lacking sources (Erik9bot)]]