Javatpoint Logo
Javatpoint Logo

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:

Sqlite Min function 1

Retrieve the lowest fees of the student from the "STUDENT" table:


Sqlite Min function 2


Using GROUP BY clause with MIN function:

Retrieve NAME and MIN FEES from the table "STUDENT" and ORDER BY the data by NAME:


Sqlite Min function 3
Next TopicSQLite Max

Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials

B.Tech / MCA