SELECT MAX(<column>) FROM <table> [WHERE <conditions>]

MAX returns the maximum value from a group of value.

Table: Orders

OrderID	Customer	Employee	Order Date	ShippedVia	Freight	ShipCountry
10248	Wilman Kala	Buchanan, Steven	04-07-1996	Federal Shipping	32.38	France
10249	Hanari Carnes	Peacock, Margaret	08-07-1996	United Package	65.83	Brazil
10250	Hanari Carnes	Leverling, Janet	08-Jul-1996	United Package	58.17	Brazil
10251	Chop-suey Chinese	Buchanan, Steven	11-Jul-1996	United Package	22.98	Switzerland
10252	Richter Supermarkt	Dodsworth, Anne	12-Jul-1996	Federal Express	148.33	Switzerland

The following SQL statement returns 148.33 from Freight column because 148.33 is the highest value in that column.

SELECT MAX(Freight) FROM Orders

Resultset1

148.33

.