> For the complete documentation index, see [llms.txt](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://vikram-bajaj.gitbook.io/cs-gy-6083-principles-of-database-systems/sql/dml-commands/where.md).

# 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 ($$\sigma \_P$$) of relational algebra.

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