SQLite MIN Function
SQLite MIN function is used to fetch the minimum value of an expression.
Syntax when you use Min function with GROUP BY clause:
We have a table named "STUDENT", having the following data:
Retrieve the lowest fees of the student from the "STUDENT" table:
Using GROUP BY clause with MIN function:
Retrieve NAME and MIN FEES from the table "STUDENT" and ORDER BY the data by NAME: