SQLite MIN Function
To fetch the lowest value from an expression, the SQLite MIN function is used.
Syntax 1:
SELECT MIN(aggregate_expression) FROM tables WHERE conditions;
Syntax 2: With GROUP BY clause
SELECT expression1, expression2, ... expression_n MIN(aggregate_expression) FROM tables WHERE conditions GROUP BY expressions;
Example 1:
TEACHERS Table:
ID NAME SALARY SUBJECT 1 Jim 10000 Geology 2 John 20000 Geology 3 Watson 15000 Physics 4 Holmes 25000 Chemistry 5 Tony 30000 Physics
SELECT MIN(SALARY) AS "MIN SALARY" FROM TEACHERS; |
Output:
MIN SALARY 10000
Explanation:
In the above example, we are calculating the minimum salary from the SALARY column of the TEACHERS table.
Example 2:
TEACHERS Table:
ID NAME SALARY SUBJECT 1 Jim 10000 Geology 2 John 20000 Geology 3 Watson 15000 Physics 4 Holmes 25000 Chemistry 5 Tony 30000 Physics
SELECT SUBJECT, MIN(SALARY) AS "MIN SALARY" FROM TEACHERS GROUP BY SUBJECT; |
Output:
SUBJECT MIN SALARY Geology 10000 Physics 15000 Chemistry 25000
Explanation:
In the above example, we are calculating the minimum salary from the SALARY column of the TEACHERS table for each unique group where grouping is done by the SUBJECT Column.