MIN and MAX

Aggregates that return the smallest and the largest non-NULL value in a group.

In more detail

They work on numbers, text and dates, comparing text by its sort order. In SQLite, min and max with two or more arguments are ordinary functions that compare those arguments instead.

Related terms

Taught in

References