SQL MAX() Function

The MAX() Function

The MAX() function returns the largest value of the selected column.

SELECT MAX(column_name) FROM table_name

We have the following "Purchases" table:

PU_ID	OrderDate	OrderPrice	Customer
1	2015/11/12	1000	Karmen
2	2015/10/23	1600	Tendulkar
3	2015/09/02	700	Karmen
4	2015/09/03	300	Karmen
5	2015/08/30	2000	Jensen
6	2015/10/04	100	Tendulkar

Now we want to find the largest value of the "OrderPrice" column.

We use the following SQL statement:

SELECT MAX(OrderPrice) AS LargestOrderPrice FROM Purchases

The result-set will look like this:

LargestOrderPrice
2000

SQL HOME
SQL Syntax
SQL Select
SQL Distinct
SQL Where
SQL And & Or
SQL Order By
SQL Insert
SQL Update

SQL Functions
SQL avg()
SQL count()
SQL first()
SQL last()
SQL max()
SQL min()
SQL sum()
SQL Group By
SQL Having
SQL ucase()
SQL lcase()
SQL mid()
SQL len()
SQL round()
SQL now()
SQL format()