SQL MIN

MIN function is used to obtain the smallest value for a given column.

MIN SQL syntax

SELECT MIN (column) FROM table

MIN SQL Example

Given the following table 'orders'

idorderclientprice
1p1HARRY100
2p2CLARK300
3p3SMITH250
4p4BROWN490
5p5WHITE60
SELECT MIN (price) FROM orders

Return the value 60, which is the smallest value in the column "price" of the query.