you are at Encyclopedia of SQL >> MIN
MIN(`column_name`)
MAX returns the smallest value of specified column. For column with text values there will be used ASCII code for comparison.Syntax
SELECT MIN(`column_name`)
FROM `table_name`
Example
Display age of the youngest person
name | surname | age |
---|---|---|
Paweł | Kowalski | 3 |
Piotr | Janik | 7 |
Michał | Nowak | 13 |
query
SELECT MIN(`age`)
FROM `people`
result
MIN(`age`) |
---|
3 |