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
- aggregate function — A function that turns many input rows into one value, such as COUNT, SUM, AVG, MIN or MAX.
Taught in
- Aggregate Functions — PostgreSQL, Indexing & Relational Data Modeling