Loading lesson path
The MIN() function returns the smallest value of the selected column. The MIN() function works with numeric, string, and date data types.
Return the lowest 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)
MIN(), the returned column will not have a name.
keyword to give the column a descriptive name:
FROM Products;