Question

What is the use of SQLite GROUP BY clause?

Answer 1

SQLite GROUP BY clause is used to collect the same elements into a group. It is used with SELECT statement.

Syntax:

SELECT column-list    

FROM table_name    

WHERE [ conditions ]    

GROUP BY column1, column2....columnN    

ORDER BY column1, column2....columnN