CodesJava

Easy learning with example program codes

MAX Function in SQLite

SQLite MAX Function
To fetch the lowest value from an expression, the SQLite MAX function is used.

Syntax 1:

SELECT MAX(aggregate_expression)  
FROM tables  
WHERE conditions;  

Syntax 2: With GROUP BY clause

SELECT expression1, expression2, ... expression_n  
MAX(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 MAX(SALARY) AS "MAX SALARY"  
FROM TEACHERS;

Output:

MAX SALARY
30000

Explanation:
In the above example, we are calculating the maximum 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, MAX(SALARY) AS "MAX SALARY"  
FROM TEACHERS
GROUP BY SUBJECT;

Output:

SUBJECT	       MAX SALARY
Geology	       20000
Physics	       30000
Chemistry      25000

Explanation:
In the above example, we are calculating the maximum 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:
error









Copyright © 2019 CodesJava DMCA.com Protection Status