MIN¶

Returns the minimum values

Syntax¶

-- As an aggregate
MIN( expr )

-- As a window function
MIN ( expr ) OVER (
         [ PARTITION BY value_expression [, ...] ]
         [ ORDER BY value_expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] ]
         [ frame_clause ]
      )

Arguments¶

Parameter	Description
`expr`	Value expression

Returns¶

Return type is dependant on the argument.

Notes¶

NULL values are ignored

Examples¶

For these examples, assume a table named nba, with the following structure:

CREATE TABLE nba
(
   "Name" varchar(40),
   "Team" varchar(40),
   "Number" tinyint,
   "Position" varchar(2),
   "Age" tinyint,
   "Height" varchar(4),
   "Weight" real,
   "College" varchar(40),
   "Salary" float
 );

Here’s a peek at the table contents (Download nba.csv):

nba.csv¶
Name	Team	Number	Position	Age	Height	Weight	College	Salary
Avery Bradley	Boston Celtics	0.0	PG	25.0	6-2	180.0	Texas	7730337.0
Jae Crowder	Boston Celtics	99.0	SF	25.0	6-6	235.0	Marquette	6796117.0
John Holland	Boston Celtics	30.0	SG	27.0	6-5	205.0	Boston University
R.J. Hunter	Boston Celtics	28.0	SG	22.0	6-5	185.0	Georgia State	1148640.0
Jonas Jerebko	Boston Celtics	8.0	PF	29.0	6-10	231.0		5000000.0
Amir Johnson	Boston Celtics	90.0	PF	29.0	6-9	240.0		12000000.0
Jordan Mickey	Boston Celtics	55.0	PF	21.0	6-8	235.0	LSU	1170960.0
Kelly Olynyk	Boston Celtics	41.0	C	25.0	7-0	238.0	Gonzaga	2165160.0
Terry Rozier	Boston Celtics	12.0	PG	22.0	6-2	190.0	Louisville	1824360.0

Simple Minimum, Maximum on numeric columns¶

t=> SELECT MIN("Age"), MAX("Age") FROM nba;
min | max
----+----
 19 |  40

Minimum and maximum on text columns¶

t=> SELECT MIN("Name"), MAX("Name") FROM nba;
min          | max
-------------+--------------
Aaron Brooks | Zaza Pachulia

Combine MIN with GROUP BY¶

t=> SELECT "Team", MIN("Salary") FROM nba GROUP BY 1 ORDER BY 2 DESC LIMIT 5;
Team                   | min
-----------------------+--------
Boston Celtics         | 1148640
Minnesota Timberwolves |  947276
Utah Jazz              |  900000
Orlando Magic          |  845059
Memphis Grizzlies      |  700902