MySQL MIN
In MySQL, the MIN function is used to get the minimum value of an expression.
Syntax:
SELECT MIN (aggregate_expression)
FROM table_name
WHERE conditions;
SELECT MIN (aggregate_expression)
FROM table_name
WHERE conditions;
SELECT MIN (aggregate_expression) FROM table_name WHERE conditions;
Parameters:
Aggregate_expression: It is used to specify the column or expression to be utilized by the MIN function.
Example: Items table:
| ID | NAME | QUANTITY |
| 1 | Electronics | 30 |
| 2 | Sports | 45 |
| 3 | Fashion | 100 |
| 4 | Grocery | 90 |
| 5 | Toys | 50 |
Query:
SELECT MIN(quantity) AS “Minimum Quantity”
FROM items;
SELECT MIN(quantity) AS “Minimum Quantity”
FROM items;
SELECT MIN(quantity) AS “Minimum Quantity” FROM items;
Output:
MINIMUM QUANTITY
30
MINIMUM QUANTITY
30
MINIMUM QUANTITY 30
Explanation:
The ‘items’ is an existing table from which we are calculating the minimum value of ‘quantity’.