min mysql 1

min mysql

//returns the minimum (lowest) value
SELECT MIN(working_hours) AS Minimum_working_hours FROM employee; 

Here is what the above code is Doing:
1. We are selecting the minimum value of the working_hours column from the employee table.
2. We are giving the result an alias of Minimum_working_hours.
3. We are using the AS keyword to give the result an alias.

Similar Posts