SQL Keywords: WHERE

The WHERE keyword is used to specify a criterion or condition, criteria or conditions, that a SQL statement must follow to perform its operation.

The WHERE keyword can be used in a SELECT statement to specify what criterion the statement must follow to select one or more records. The formula to follow is:

SELECT What FROM WhatObject WHERE Expression;

Here is an example where all records are selected from a table but only records where the Gender value is Male would be kept:

SELECT * FROM Students WHERE Gender="Male";

Here is an example where the names of of tables and columns are included in square brackets and the names of columns are qualified with periods:

SELECT [Students].[FirstName], [Students].[LastName]
FROM [Students]
WHERE [Students].[Gender]="Male";

Here is an example that uses the <> operator:

SELECT * FROM Students WHERE Gender<>"Male";

• AS
• ASC
• BY
• DESC
• ORDER
• SELECT