GROUP BY Clause in SQLite

SQLite GROUP BY Clause To group similar elements, from a table after fetching the records the GROUP BY clause is used in the SELECT statement. It is used with the WHERE clause before the ORDER BY clause.

Syntax:

SELECT column-list  
FROM table_name  
WHERE conditions 
GROUP BY column1, column2...column_N  
ORDER BY column1, column2...column_N [ASC | DESC];

Example 1: TEACHERS Table:

SELECT SUBJECT, SUM(SALARY) AS “SUM SALARY”
FROM TEACHERS 
GROUP BY SUBJECT;

Output:

Explanation: In the above example, the SUM of the salary is grouped by the SUBJECT Column.

Example 2: TEACHERS Table:

SELECT SUBJECT, SUM(SALARY) 

FROM TEACHERS 
GROUP BY SUBJECT
ORDER BY SUBJECT ASC;

Output:

Explanation: In the above example, the SUM of the salary is grouped by the SUBJECT Column and is then ordered in Ascending order by the SUBJECT Column.

Please follow and like us: