The SQL MIN aggregate function is used to determine the smallest values respectively in a column.

The SQL MIN syntax is looks like this:

SELECT MIN ( [COLUMN NAME] )
FROM
[TABLE NAME]


EXAMPLE :

We can see with a simple example which is return smallest value of the scores in the table.

Table GameScores

PlayerNameDepartmentScores
JasonIT3000
IreneIT1500
JaneMarketing1000
DavidMarketing2500
PaulHR2000
JamesHR2000

SQL statement :

SELECT MIN(Scores)
FROM
GameScores

Result:

MIN(Scores)
1000