Creating SQL with multiple grouping sets.

创建具有多个分组集的sql。

youdao

This ROLLUP ends up being equivalent to the following grouping sets.

最终的这个ROLLUP相当于以下分组集。

youdao

Multiple slices of data can be returned in a single query by using grouping sets or super-groups (such as ROLLUP) in the GROUP-BY clause of the SQL statement.

通过在sql语句的GROUP BY子句中使用多个分组集或超级组(比如rollup)，可以在一个查询中返回数据的多个切片。

youdao