阅读背景:

如何在select语句中使用分组集的分组子句?

来源:互联网 

I just learned of using the grouping sets clause and I believe I can re write one of my old queries. Currently, it is a union of 5 different groupings coming from a CTE. I understand that I should be easily able to change that into the different hierarchies they are being grouped into with grouping sets of even rollup, but I need to specify a literal at each level or grouping. I can't show you my actual code, but I have an example below.I just learned of using the grouping sets claus




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: