SQL WHERE

Internal

• SQL SELECT
• SQL UPDATE
• SQL DELETE

Overview

The WHERE clause is the mechanism for filtering out unwanted data from the result set. The WHERE clause can be used with SELECT, UPDATE and DELETE, but not with INSERT.

SELECT * FROM person WHERE person.name = 'Alice';

Filters, conditions, condition evaluation.

Conditions

NULL in Conditions

Also see:

NULL