MariaDB Min Function

MariaDB MIN() Function

MariaDB MIN() functiuon is used to retrieve the minimum value of the expression.

Syntax:

Example:

We have a table “Student”, having the following data:

MariaDB Min function 1

Let’s retrieve lowest salary by using MIN () function.

Output:

MariaDB Min function 2

 SELECT student_name, MIN(salary) AS “Lowest Salary” FROM Student where student_id < 10 GROUP BY student_id; 

Output:

MariaDB Min function 3