SQL WHERE

From NovaOrdis Knowledge Base
Revision as of 22:04, 23 May 2024 by Ovidiu (talk | contribs)
Jump to navigation Jump to search

Internal

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';

The WHERE clause may contain an arbitrary number of filter conditions separated by AND, OR and NOT operators, and optimally grouped together with parentheses.

  FROM <filter_condition> AND|OR <filter_condition> ...

Filter Conditions

NULL in Conditions

Also see:

NULL