What is the use of SQLite GROUP BY clause?

SQLite - Interview Questions

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

More Technologies Interview Questions