HAVING Clause in SQLite

SQLite HAVING Clause
To specify conditions for the groups created by the GROUP BY clause, the SQLite HAVING clause is used with the GROUP BY clause in the SELECT statement.

Syntax:

SELECT columns
FROM table_name  
WHERE conditions
GROUP BY columns
HAVING conditions 
ORDER BY columns

Example 1:
TEACHERS Table:

SELECT SUBJECT, SUM(SALARY) 
FROM TEACHERS 
GROUP BY SUBJECT
HAVING SUM(SALARY) <= 30000;

Output:

Explanation:
In the above example, all the records are grouped by the SUBJECT Column where the sum of the SALARY column is less than or equal to 30000.

Example 2:

SELECT SUBJECT, SUM(SALARY) 
FROM TEACHERS 
GROUP BY SUBJECT
HAVING SUM(SALARY) <= 30000   
ORDER BY SUBJECT ASC;

Output:

Explanation:
In the above example, all the records are grouped by the SUBJECT Column where the sum of the SALARY column is less than or equal to 30000. The result so obtained is then ordered in Ascending order by the SUBJECT Column.