Loading lesson path
The MAX() function returns the largest value of the selected column. The MAX() function works with numeric, string, and date data types.
Return the highest price in the Price column, in the "Products" table:
FROM Products;column_name )
table_name
condition
;Products table used in the examples:
10 boxes x 20 bags 18.00
Formula
24 - 12 oz bottles19.00
Formula
12 - 550 ml bottles10.00
Formula
48 - 6 oz jars22.00
36 boxes 21.35 Set Column Name (Alias)
MAX(), the returned column will not have a name.
keyword, to give the column a descriptive name:
FROM Products;