CUBE运算符是在Select语句的group by子句中指定的,group by应指定维度列和关键字with cube,结果集将包括维度列中各值的所有可能组合. 示例1. Sql语句如下: select * from student select sex,sclass,sum(score) as 合计 from student group by sex,sclass with cube select sex,sclass,sum(score) as 合计 ...
1. 2. 3. Select CategoryID, SupplierID, SUM(UnitPrice) AS SumPrice FROM dbo.Products GROUP BY CategoryID, SupplierID WITH CUBE它会产生一个交叉表,产生所有可能的组合汇总。 SQL Server group by 的用法 6、使用 ROLLUP CUBE 会产生一个 NULL 空值,可以使 用以下语法解决,如下: ...