MySQL group data _ MySQL-mysql tutorial

MySQL Group Data Group

For group understanding, see the next example. First, we print the products table as follows:

From the table above, we can see that each vendor has several products. how can we count the number of products in each vendor at a time? You can use group by here, as shown below:

If you do not use group by, the result is the number of rows in the statistics:

Group filtering

Grouping filtering is to filter the data after multiple statistics. in the example above, statistics show that each vendor has multiple products, HAVING can be used to filter out more than three vendors:

The WHERE statement can be used together with the HAVING Statement. if you need to find out, there are two or more products with a price greater than 10: