Min Syntax:
SELECT MIN(column_name)
FROM table_name
Sales table:
| ID | PRICE | NAME |
|---|---|---|
| 1 | 200 | A |
| 2 | 500 | B |
| 3 | 900 | C |
| 4 | 500 | D |
Min Example:
SELECT MIN(price) FROM store;
SELECT MIN(column_name)
FROM table_name
| ID | PRICE | NAME |
|---|---|---|
| 1 | 200 | A |
| 2 | 500 | B |
| 3 | 900 | C |
| 4 | 500 | D |
SELECT MIN(price) FROM store;