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.

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

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