SQL MAX () function

MAX () function

The Max function returns the maximum value in a column. NULL values are not included in the calculation.

SQL MAX () syntax

SELECT MAX (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 MAX () 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 maximum value for the "Orderprice" column.

We use the following SQL statement:

SELECT MAX (Orderprice) as Largestorderprice from Orders

The result set looks like this:

Largestorderprice
2000

SQL MAX () function