An optional clause of the SELECT statement that constrains the number of rows returned by the query.

Operator to check if a value is NULL or not.

The clause is used in the SELECT statement to remove duplicate rows from a result set. It keeps one row for each group of duplicates.

To conform with the SQL standard, PostgreSQL supports this clause to retrieve a number of rows returned by a query.