To get the minimum value from a column in the table, the MariaDB MIN function is used.

Syntax:

SELECT expressions,
MIN (aggregate_expression)
FROM table_name
WHERE conditions;


Parameters:
Aggregate_expression: It is used to specify the column or expression to be utilised by the aggregate function.

Example 1: Using Group By Clause.
Players Table:

ID	NAME	        SPORTS	        INCOME
1	Sachin	        Cricket	        5000000
2	Dhoni	        Cricket	        8000000
3	Sunil	        Football	2000000
5	Mary	        Boxing	        3000000


Query:

SELECT sports, MIN(income) AS “Minimum Income” FROM Players GROUP BY sports;

Output:

SPORTS	        Minimum Income
Cricket	        5000000
Football	2000000
Boxing	        3000000


Explanation:
The ‘Players’ is an already existing table. Here we are retrieving the minimum value of the income of the players of the same SPORTS group, using the Group By clause with an aggregate function MIN.

Example 2:
Players Table:

ID	NAME	       SPORTS	      INCOME
1	Sachin	       Cricket	      5000000
2	Dhoni	       Cricket	      8000000
3	Sunil	       Football	      2000000
5	Mary	       Boxing	      3000000


Query:

SELECT MIN(income) FROM Players;

Output:

1000000

Explanation:
The minimum value of the INCOME is the result.