CUBE|ROLLUP|GROUPING SETSs.GROUPING SETS can also have nested CUBE|ROLLUP|GROUPING SETS clauses, e.g.GROUPING SETS(ROLLUP(warehouse, location), CUBE(warehouse, location)), GROUPING SETS(warehouse, GROUPINGFor nested GROUPING SETS in the
假设我有一个名为table1的表,例如,它对应的列是col1、col2、col3和col4。-- note that the following query will not work FROM table1 FROM table1 我必须在我的数据库中合并col1和col2才能工作吗?如果我将col1和col2合并到col1_2
as recordid1, grouping1b.systemid as systemid2,grouping1b.recordid as recordid2 from #grouping1 as grouping1ainner join where not (grouping1a.SYSTEMIDfr