sqliteHow can I use the GROUP BY clause in SQLite?
The GROUP BY clause in SQLite is used to group together rows of data based on a given field or expression. It is used in conjunction with aggregate functions such as COUNT, SUM, AVG, MIN and MAX.
For example, the following query groups the data by the 'department' field and returns the total number of employees in each department:
SELECT department, COUNT(*)
FROM employees
GROUP BY department;Output example
department COUNT(*)
---------- --------
sales 10
marketing 5
engineering 15The query consists of the following parts:
-
SELECT: The SELECT clause specifies the fields to be returned in the result set. In this case, it is the 'department' field and the COUNT aggregate function.
-
FROM: The FROM clause specifies the table from which to retrieve the data. In this case, it is the 'employees' table.
-
GROUP BY: The GROUP BY clause specifies the field or expression by which to group the data. In this case, it is the 'department' field.
-
COUNT: The COUNT aggregate function returns the number of rows in each group.
Helpful links
More of Sqlite
- How do I call sqlitepcl.raw.setprovider() when using SQLite?
- How do I use SQLite with Zephyr?
- How do I use the SQLite ZIP VFS to compress a database?
- How do I use the SQLite zfill function?
- How can I use the XOR operator in a SQLite query?
- How can I use SQLite online?
- How can I use SQLite with Zabbix?
- How do I extract the year from a datetime value in SQLite?
- How do I use the SQLite sequence feature?
- How do I use SQLite to zip a file?
See more codes...