WHERE Clause Example

This example assumes the existence of a hypothetical Salary field in an Employees table. Note that this field does not actually exist in the Northwind database Employees table. The example selects the LastName and FirstName fields of each record in which the last name is King.

SELECT LastName, FirstName FROM Employees 
WHERE LastName = 'King';