SQL MIN () function

MIN () function

The Min function returns the minimum value in a column. NULL values are not included in the calculation.

SQL MIN () syntax

SELECT MIN (column_name) from table_name

Note: MIN and MAX can also be used for text columns to get the highest or lowest values in alphabetical order.

SQL MIN () instance

We have the following "Orders" table:

o_id	OrderDate	Orderprice	Customer
1	2008/12/29	1000	Bush
2	2008/11/23	1600	Carter
3	2008/10/05	700	Bush
4	2008/09/28	300	Bush
5	2008/08/06	2000	Adams
6	2008/07/21	100	Carter

Now, we want to find the minimum value for the "Orderprice" column.

We use the following SQL statement:

SELECT MIN (Orderprice) as Smallestorderprice from Orders

The result set looks like this:

Smallestorderprice
100

SQL MIN () function