Javatpoint Logo
Javatpoint Logo

SQLite MAX Function

SQLite MAX function is used to fetch the maximum value of an expression.


Syntax when you use MAX function with GROUP BY clause:


We have a table named "STUDENT", having the following data:

Sqlite Max function 1

Retrieve the highest fees of the student from the "STUDENT" table.


Sqlite Max function 2


Using GROUP BY clause with MAX function:

Retrieve NAME, CITY and MAX FEES from the table "STUDENT" and ORDER BY the data by CITY:


Sqlite Max function 3
Next TopicSQLite Avg

Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials

B.Tech / MCA