更新时间:2022-09-13 21:40:13
GROUP BY语句用于根据一个或多个列对结果集进行分组。
SELECT [ DISTINCT ]
{ * | projectItem [, projectItem ]* }
FROM tableExpression
[ GROUP BY { groupItem [, groupItem ]* } ];
Customer | OrderPrice |
---|---|
Bush | 1000 |
Carter | 1600 |
Bush | 700 |
Bush | 300 |
Adams | 2000 |
Carter | 100 |
SELECT Customer,SUM(OrderPrice) FROM XXXX
GROUP BY Customer;
Customer | SUM(OrderPrice) |
---|---|
Bush | 2000 |
Carter | 1700 |
Adams | 2000 |