[
https://issues.apache.org/jira/browse/TRAFODION-2909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16329569#comment-16329569
]
ASF GitHub Bot commented on TRAFODION-2909:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1399#discussion_r162192952
--- Diff:
docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc ---
@@ -6337,6 +6337,300 @@ UPDATE persnl.job
SET jobdesc = RIGHT (jobdesc, 12);
```
+<<<
+[[rollup_function]]
+== ROLLUP Function
+
+The ROLLUP function calculates multiple levels of subtotals aggregating
from right to left through the comma-separated list of columns, and provides a
grand total. It is a an extension to the `GROUP BY` clause and can be used with
`ORDER BY` to sort the results.
+
+```
+SELECT…GROUP BY ROLLUP (column 1, [column 2,]…[column n])
+```
+
+ROLLUP generates n+1 levels of subtotals and grand total, where n is the
number of the selected column(s).
+
+For example, a query that contains three rollup columns returns the
following rows:
+
+* First-level: stand aggregate values calculated by GROUP BY clause
without using ROLLUP.
--- End diff --
Possible wordsmith: "the usual aggregate values as calculated..."
> Add ROLLUP Function for *Trafodion SQL Reference Manual*
> ---------------------------------------------------------
>
> Key: TRAFODION-2909
> URL: https://issues.apache.org/jira/browse/TRAFODION-2909
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: Liu Yu
> Assignee: Liu Yu
> Priority: Major
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
