Tips and Tricks on SQL Max: Learn to use Max Function in SQL

SQL MAX function returns the biggest data record value from the specified column.

Syntax of SQL MAX

 Example  

SELECT MAX(col_name)
FROM tbl_name
WHERE conditions;

The demo database we'll use in our examples is called Products:

ID	Name	Supplier_ID	Category_ID	Unit	Price	Unit_in_stock	Unit_on_order
1	Cucumber	3	3	5 crates	19	17	16
2	Tomato	3	3	6 crates	20	24	Null
3	Cheese	3	4	5 kg boxes	11	11	6
4	Milk	4	4	5 L bottles	22	56	12
5	Bread	4	4	36 boxes	26	26	1

The code example below pick out the biggest 'PriceID' data record value in the table Products:

Example

SELECT MAX(Price) AS HighestPrice FROM Products;