Oracle 聚合函数grouping sets,cube,ROLLUP
1.grouping sets分别对其中的聚合组进行聚合(即 group by null; group by A; group by A,B 进行union all)select null,A,B,count© c_num from tablegroup bygrouping sets(null,A,(A,B))2.cube相当于对 group by null;group by A,NULL;group by NULL,B;group by A,B 进行union allselect A,B,
原创
2021-03-30 11:23:55 ·
245 阅读 ·
0 评论