SQLite MIN FunctionSQLite MIN function is used to fetch the minimum value of an expression. Syntax: Syntax when you use Min function with GROUP BY clause: Example1: We have a table named "STUDENT", having the following data: ![]() Retrieve the lowest fees of the student from the "STUDENT" table: Output: ![]() Example2: Using GROUP BY clause with MIN function: Retrieve NAME and MIN FEES from the table "STUDENT" and ORDER BY the data by NAME: Output: ![]()
Next TopicSQLite Max
|