[ https://issues.apache.org/jira/browse/TRAFODION-2520?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15898654#comment-15898654 ]
ASF GitHub Bot commented on TRAFODION-2520: ------------------------------------------- Github user liuyu000 commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/990#discussion_r104579867 --- Diff: docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc --- @@ -133,12 +145,21 @@ GROUP BY num, workgroupnum, annualsalary; [[limitations_for_window_functions]] == Limitations for Window Functions -These limitations apply to all window functions. +Trafodion supports many ANSI compliant OLAP window functions. These functions include AVG, COUNT, DENSE_RANK, MAX, MIN, RANK, ROW_NUMBER, STDDEV, SUM, and VARIANCE. However, Trafodion imposes certain limitations on all window functions. --- End diff -- Thanks Hans. Your comment has been incorporated. :) > Add details for OLAP function + Add LEAD, LAG, FIRST_VALUE & LAST_VALUE > window functions > ---------------------------------------------------------------------------------------- > > Key: TRAFODION-2520 > URL: https://issues.apache.org/jira/browse/TRAFODION-2520 > Project: Apache Trafodion > Issue Type: Documentation > Reporter: Liu Yu > Assignee: Liu Yu > -- This message was sent by Atlassian JIRA (v6.3.15#6346)