Difference between revisions 582862177 and 595886302 on enwiki

< previous diff
next diff >
Where (SQL)
{{Unreferenced|date=April 2007}}
A <code>WHERE</code> clause in [[SQL]] specifies that a SQL [[Data Manipulation Language|Data Manipulation Language (DML)]] statement should only affect rows that meet specified criteria. The criteria are expressed in the form of predicates. <code>WHERE</code> clauses are not mandatory clauses of SQL DML statements, but can be used to limit the number of rows affected by a SQL DML statement or returned by a query. In brief SQL WHERE clause is used to extract only those results from a SQL statement, such as: SELECT, INSERT, UPDATE, or DELETE statement.<ref>{{cite web|url=http://www.programmingunit.com/2014/01/30/sql-clause-things-beginners-must-know/|title=SQL WHERE Clause – Things beginners must know}}</ref>

==Overview==
<code>WHERE</code> is an [[SQL:2003|SQL]] reserved word.

The <code>WHERE</code> clause is used in conjunction with SQL DML statements, and takes the following general form:

<source lang="sql">
(contracted; show full)
== References ==
<references />

{{SQL}}

{{DEFAULTSORT:Where (Sql)}}
[[Category:SQL keywords]]