Condition (SQL): Difference between revisions

Revision as of 03:47, 14 July 2010

Revision as of 17:52, 14 July 2010

Line 1:

{{Unreferenced|date=December 2009}}

{{Orphan|date=December 2009}}

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

== Types of condition ==

{{Expand section|date=July 2010}}

{{sectstub}}

* Many conditions compare values for (for example) equality, inequality or similarity.

* The EXISTS condition uses the [[SQL:2003 | SQL standard]] [[SQL keywords | keyword]] <code>EXISTS</code><ref>

{{cite book

|last= Fehily

Line 18 ⟶ 17:

|publisher= Peachpit Press

|isbn= 978-0-321-33417-6

|pages= 439–440

|page= 439-440

|pages= 480

|quote= SQL Keywords [...] The appendix lists the [[SQL:2003]] standard's reserved and non-reserved keywords. [...] EXISTS [...]

Line 49 ⟶ 48:

== References ==

{{reflistReflist}}

{{DEFAULTSORT:Condition (Sql)}}

[[ru:Условие в SQL-запросе]]

[[Category:SQL]]

[[ru:Условие в SQL-запросе]]