a-rafay commented on a change in pull request #2444:
URL: https://github.com/apache/calcite/pull/2444#discussion_r659103527
##########
File path: site/_docs/reference.md
##########
@@ -1861,6 +1861,29 @@ Not implemented:
* REGR_SLOPE(numeric1, numeric2)
* REGR_SXY(numeric1, numeric2)
+#### Ordered-Set Aggregate Functions
+
+Syntax:
+
+{% highlight sql %}
+aggregateCall:
+ agg '(' value ')'
+ WITHIN GROUP '(' ORDER BY orderItem [ ASC | DESC ] ')'
+{% endhighlight %}
+
+where *agg* is one of the operators in the following table.
+
+The aggregate function sorts the input rows according to the `ORDER BY` clause
+inside `WITHIN GROUP` before aggregating values. The sorting can be ascending
or
+descending (ascending by default if not specified). All the aggregate
functions which
Review comment:
Done.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
