MIN Function
Next: SQL SUM
SQL uses the MIN function to find the maximum value in a column. The syntax for using the MIN function is,
SELECT MIN("column_name")
FROM "table_name"
For example, if we want to get the lowest sales from the following table,
Table Store_Information
store_name | Sales | Date |
Los Angeles | $1500 | Jan-05-1999 |
San Diego | $250 | Jan-07-1999 |
Los Angeles | $300 | Jan-08-1999 |
Boston | $700 | Jan-08-1999 |
we would type in
SELECT MIN(Sales) FROM Store_Information
Result:
MIN(Sales) |
$250 represents the minimum value of all Sales entries: $1500, $250, $300, and $700.