MIN() Function in SQLite

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 Share