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.
Please follow and like us: