举例 oracle 分组函数（　rollup( ) , cube( ) , sets ( ) )-优快云博客

本文深入解析了Oracle中分组函数rollup(), cube(), sets()及其与GROUP BY结合的用法，通过具体示例展示了如何使用GROUPINGSETS实现灵活的分组操作，并提供了与GROUP BY的等效语句比较，帮助读者理解并掌握这些高级分组技巧。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

举例 oracle 分组函数（　rollup( ) , cube( ) , sets ( ) )

GROUPING SETS Statement	Equivalent GROUP BY Statement
GROUP BY GROUPING SETS(a, b, c)	GROUP BY a UNION ALL GROUP BY b UNION ALL GROUP BY c
GROUP BY GROUPING SETS(a, b, (b, c))	GROUP BY a UNION ALL GROUP BY b UNION ALL GROUP BY b, c
GROUP BY GROUPING SETS((a, b, c))	GROUP BY a, b, c
GROUP BY GROUPING SETS(a, (b), ())	GROUP BY a UNION ALL GROUP BY b UNION ALL GROUP BY ()
GROUP BY GROUPING SETS(a, ROLLUP(b, c))	GROUP BY a UNION ALL GROUP BY ROLLUP(b, c)

GROUP BY ROLLUP(a, (b, c))

This is equivalent to:

GROUP BY a, b, c UNION ALL
GROUP BY a UNION ALL
GROUP BY ()

-------------------------------------------------------------------------

Similarly, the following statement is equivalent to the four GROUP BYs:

GROUP BY CUBE((a, b), c)

GROUP BY a, b, c UNION ALL
GROUP BY a, b UNION ALL
GROUP BY c UNION ALL
GROUP By ()

-------------------------------------------------------------------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25380220/viewspace-712863/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25380220/viewspace-712863/

举例 oracle 分组函数（ rollup( ) , cube( ) , sets ( ) )