Back Where (SQL) Catalan WHERE Czech WHERE (SQL) Japanese WHERE (SQL) Korean Where (SQL) Dutch Where (SQL) NB Where (SQL) Portuguese Where (SQL) Russian Where (SQL) Albanian Where (SQL) Ukrainian
&sq=Albert Einstein&lang=en&file=File:Question_book-new.svg){kind=small} | This article needs additional citations for verification. (September 2014) |
A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria. The criteria are expressed in the form of predicates. WHERE 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.[1]