SQL · Functions and expressions

Greatest / least

Returns the largest or smallest of the arguments. PostgreSQL and SQLite differ in null handling.

sqlRunnable example sql course

Syntax

greatest(a, b)

Example

Open in the lab

SELECT max(3, 7) AS larger;

SQLite uses max()/min() with multiple arguments; PostgreSQL uses GREATEST/LEAST.

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.