10分组数据

分组数据

1.创建分组——group by子句

group by用来筛选不同值，并按照这些不同值进行分组。

select cust_id, sum(price) as sum_price
from Customers
group by cust_id;

2.过滤分组——having子句

用于group by之后筛选分组的数据

select cust_id, sum(price) as sum_price
from Customers
group by cust_id
Having cust_id BETWEEN '0001' AND '0009';
发布于