Where

The where clause is used to specify a predicate. It is used along with the select and from clauses.

It corresponds to the selection predicate operation (σP\sigma _P) of relational algebra.

Logical connectives like and, or, not can be used.

Last updated