[
https://issues.apache.org/jira/browse/TRAFODION-2909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16329568#comment-16329568
]
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_r162192522
--- 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.
--- End diff --
There is no "ORDER BY ROLLUP" syntax. But it looks like there are functions
such as GROUPING that can refer to whether a column is used as a grouping
column in a rollup result row, so one can order the detail vs. the summary
rows. There's also a small typo here "...is a an..." Possible wordsmith for the
last sentence: "It is an extension to the 'GROUP BY' clause. Related features
such as the GROUPING function can be used with 'ORDER BY' to control the
placement of summary results."
> 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)
