GROUP BY 语句_查询概述_Spark Streaming SQL_开发指南_E-MapReduce

2020-02-10 分类：阿里云帮助文档 阅读(1867) 评论(0)

GROUP BY 语句

GROUP BY 语句用于根据一个或多个列对结果集进行分组。

语法

SELECT [ DISTINCT ]
{ * | projectItem [, projectItem ]* }
FROM tableExpression
[ GROUP BY { groupItem [, groupItem ]* } ];

示例

SELECT Customer, SUM(OrderPrice) FROM xxx
GROUP BY Customer;