Database Grouping Query

The grouping query uses aggregate functions to return statistical results for all row data. If you need to classify the values of a column of data and then query on the basis of the classification, you will use the GROUP BY clause. 1. General Simple grouping

2. General group query with HAVING clause after you have finished querying and counting data results, you can use the Having keyword to further filter the results of queries and statistics.





Note: Aggregate functions are generally used in 3 places, that is, the SELECT clause, the COMPUTE clause, and the HAVING clause.

Database Grouping Query