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

Store Sales Information

type in

SELECT MIN(Sales) FROM Store_Information

Result:
MIN(Sales)
$250

$250 represents the minimum value of all Sales entries: $1500, $250, $300, and $700.