MAX() Function gets the largest value of the specified numeric column on which it is used.
SQL MAX() Syntax
SELECT MAX(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 MAX() Example
Text Editor below has the SQL Query, click the "View Result" button, to see the result.
To retrieve the largest value in the Amount column in the Orders Table.
Select MAX(Amount) as MaxAmount from Orders;
SQL in Text Editor: