Min() function gets the smallest value of the specified numeric column on which it is used.
SQL Min() Syntax
SELECT Min(column_name)
FROM table_name
Below is shown the "Orders" table:
D001 |
C001 |
4/3/2007 12:00:00 AM |
150.23 |
D002 |
C003 |
1/22/2005 12:00:00 AM |
123.57 |
D003 |
C005 |
3/19/2003 12:00:00 AM |
220.43 |
D004 |
C007 |
7/21/2008 12:00:00 AM |
157.72 |
D005 |
C008 |
2/28/2009 12:00:00 AM |
223.78 |
D006 |
C011 |
3/21/2005 12:00:00 AM |
245.34 |
SQL Min() Example
Text Editor below has the SQL Query, click the "View Result" button, to see the result.
To retrieve the smallest value of the Amount column in the Orders table.
Select Min(Amount) as MaxAmount from Orders;
SQL in Text Editor: