You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by gt...@apache.org on 2016/11/03 06:05:38 UTC
[08/15] incubator-trafodion git commit: Major reorganization of the
Client Installation Guide.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/da748b4d/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc b/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc
index 8923214..d6ace1b 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/olap_functions.adoc
@@ -1,1078 +1,1078 @@
-////
-/**
-* @@@ START COPYRIGHT @@@
-*
-* Licensed to the Apache Software Foundation (ASF) under one
-* or more contributor license agreements. See the NOTICE file
-* distributed with this work for additional information
-* regarding copyright ownership. The ASF licenses this file
-* to you under the Apache License, Version 2.0 (the
-* "License"); you may not use this file except in compliance
-* with the License. You may obtain a copy of the License at
-*
-* http://www.apache.org/licenses/LICENSE-2.0
-*
-* Unless required by applicable law or agreed to in writing,
-* software distributed under the License is distributed on an
-* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-* KIND, either express or implied. See the License for the
-* specific language governing permissions and limitations
-* under the License.
-*
-* @@@ END COPYRIGHT @@@
-*/
-////
-
-[[olap_functions]]
-= OLAP Functions
-
-This section describes the syntax and semantics of the On Line
-Analytical Process (OLAP) window functions. The OLAP window functions
-are ANSI compliant.
-
-[[considerations_for_window_functions]]
-== Considerations for Window Functions
-
-These considerations apply to all window functions.
-
-* `_inline-window-specification_`
-+
-The window defined by the _inline-window-specification_ consists of the
-rows specified by the _window-frame-clause_, bounded by the current
-partition. If no PARTITION BY clause is specified, the partition is
-defined to be all the rows of the intermediate result. If a PARTITION BY
-clause is specified, the partition is the set of rows which have the
-same values for the expressions specified in the PARTITION clause.
-
-* `_window-frame-clause_`
-+
-DISTINCT is not supported for window functions.
-+
-Use of a FOLLOWING term is not supported. Using a FOLLOWING term results
-in an error.
-+
-If no _window-frame-clause_ is specified, "ROWS BETWEEN UNBOUNDED
-PRECEDING AND UNBOUNDED FOLLOWING" is assumed. This clause is not
-supported because it involves a FOLLOWING term and will result in an
-error.
-+
-"ROWS CURRENT ROW" is equivalent to "ROWS BETWEEN CURRENT ROW AND
-CURRENT ROW".
-+
-"ROWS _preceding-row_" is equivalent to "ROWS BETWEEN _preceding-row_
-AND CURRENT ROW".
-
-=== Nulls
-
-All nulls are eliminated before the function is applied to the set of
-values. If the window contains all NULL values, the result of the window
-function is NULL.
-
-If the specified window for a particular row consists of rows that are
-all before the first row of the partition (no rows in the window), the
-result of the window function is NULL.
-
-<<<
-[[order_by_clause_supports_expressions_for_olap_functions]]
-== ORDER BY Clause Supports Expressions For OLAP Functions
-
-The ORDER BY clause of the OLAP functions now supports expressions.
-However, use of multiple OLAP functions with different expressions in
-the same query is not supported. The following examples show how
-expressions may be used in the ORDER BY clause.
-
-```
-SELECT
- -1 * annualsalary neg_total
-, RANK() OVER (ORDER BY -1 * annualsalary) olap_rank
-FROM employee;
-```
-
-Using an aggregate in the ORDER BY clause:
-
-```
-SELECT
- num
-, RANK() OVER (ORDER BY SUM(annualsalary)) olap_rank
-FROM employee
-GROUP BY num;
-```
-
-Using multiple functions with the same expression in the ORDER BY clause:
-
-```
-SELECT
- num
-, workgroupnum
-, RANK() OVER (ORDER BY SUM (annualsalary)*num) olap_rank
-, DENSE_RANK() OVER (ORDER BY SUM (annualsalary)*num) olap_drank
-, ROW_NUMBER() OVER (ORDER BY SUM (annualsalary)*num) olap_mum
-FROM employee
-GROUP BY num, workgroupnum, annualsalary;
-```
-
-Using more functions with the same expression in the ORDER BY clause:
-
-```
-SELECT
- num
-, workgroupnum
-, annualsalary
-, SUM(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
-, AVG(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
-, MIN(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
-, MAX(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
-, VARIANCE(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
-, STDDEV(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
-, COUNT(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
-FROM employee
-GROUP BY num, workgroupnum, annualsalary;
-```
-
-<<<
-[[limitations_for_window_functions]]
-== Limitations for Window Functions
-
-These limitations apply to all window functions.
-
-* The ANSI _window-clause_ is not supported by {project-name}. Only the
-_inline-window-specification_ is supported. An attempt to use an ANSI
-_window-clause_ will result in a syntax error.
-
-* The _window-frame-clause_ cannot contain a FOLLOWING term, either
-explicitly or implicitly. Because the default window frame clause
-contains an implicit FOLLOWING ("ROWS BETWEEN UNBOUNDED PRECEDING AND
-UNBOUNDED FOLLOWING"), the default is not supported. So, practically,
-the _window-frame-clause_ is not optional. An attempt to use a FOLLOWING
-term, either explicitly or implicitly will result in the "4343" error
-message.
-
-* The window frame units can only be ROWS. RANGE is not supported by
-{project-name}. An attempt to use RANGE will result in a syntax error.
-
-* The ANSI _window-frame-exclusion-specification_ is not supported by
-{project-name}. An attempt to use a _window-frame-exclusion-specification_
-will result in a syntax error.
-
-* Multiple _inline-window-specifications_ in a single SELECT clause are
-not supported. For each window function within a SELECT clause, the
-ORDER BY clause and PARTITION BY specifications must be identical. The
-window frame can vary within a SELECT clause. An attempt to use multiple
-_inline-window-specifications_ in a single SELECT clause will result in
-the "4340" error message.
-
-* The ANSI _null-ordering-specification_ within the ORDER BY clause is
-not supported by {project-name}. Null values will always be sorted as if they
-are greater than all non-null values. This is slightly different than a
-null ordering of NULLS LAST. An attempt to use a
-_null-ordering-specification_ will result in a syntax error.
-
-* The ANSI _filter-clause_ is not supported for window functions by
-{project-name}. The _filter-clause_ applies to all aggregate functions
-(grouped and windowed) and that the _filter-clause_ is not currently
-supported for grouped aggregate functions. An attempt to use a
-_filter-clause_ will result in a syntax error.
-
-* The DISTINCT value for the _set-qualifier-clause_ within a window
-function is not supported. Only the ALL value is supported for the
-_set-qualifier-clause_ within a window function. An attempt to use
-DISTINCT in a window function will result in the "4341" error message.
-
-<<<
-[[avg_window_function]]
-== AVG Window Function
-
-AVG is a window function that returns the average of non-null values of
-the given expression for the current window specified by the
-_inline-window specification_.
-
-```
-AVG ([ALL] expression) OVER (inline-window-specification)
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-[ window-frame-clause ]
-```
-
-* `_window-frame-clause_` is:
-+
-```
- ROWS CURRENT ROW
-| ROWS preceding-row
-| ROWS BETWEEN preceding-row AND preceding-row
-| ROWS BETWEEN preceding-row AND CURRENT ROW
-| ROWS BETWEEN preceding-row AND following-row
-| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
-| ROWS BETWEEN CURRENT ROW AND following-row
-| ROWS BETWEEN following-row AND following-row
-```
-
-* `_preceding-row_` is:
-+
-```
- UNBOUNDED PRECEDING
-| unsigned-integer PRECEDING
-```
-
-* `_following-row_` is:
-+
-```
- UNBOUNDED FOLLOWING
-| unsigned-integer FOLLOWING
-```
-
-<<<
-* `ALL`
-+
-specifies whether duplicate values are included in the computation of
-the AVG of the _expression_. The default option is ALL, which causes
-duplicate values to be included.
-
-* `_expression_`
-+
-specifies a numeric or interval value _expression_ that determines the
-values to average. See <<numeric_value_expressions,Numeric Value Expressions>>
-and <<interval_value_expressions,Interval Value Expressions>>.
-
-* `_inline-window-specification_`
-+
-specifies_the_window_over_which_the_avg_is_computed. The
-_inline-window-specification_ can contain an optional partition by
-clause, an optional ORDER BY clause and an optional window frame clause.
-The PARTITION BY clause specifies how the intermediate result is
-partitioned and the ORDER BY clause specifies how the rows are ordered
-within each partition.
-
-* `_window-frame-clause_`
-+
-specifies the window within the partition over which the AVG is
-computed.
-
-<<<
-[[examples_of_avg_window_function]]
-=== Examples of AVG Window Function
-
-* Return the running average value of the SALARY column:
-+
-```
-SELECT
- empnum
-, AVG(salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the running average value of the SALARY column within each
-department:
-+
-```
-SELECT
- deptnum
-, empnum
-, AVG(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the moving average of salary within each department over a
-window of the last 4 rows:
-+
-```
-SELECT
- deptnum
-, empnum
-, AVG(SALARY) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
-FROM persnl.employee;
-```
-
-<<<
-[[count_window_function]]
-== COUNT Window Function
-
-COUNT is a window function that returns the count of the non null values
-of the given expression for the current window specified by the
-inline-window-specification.
-
-```
-COUNT {(*) | ([ALL] expression) } OVER inline-window-specification
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-[ window-frame-clause ]
-```
-
-* `_window-frame-clause_` is:
-+
-```
- ROW CURRENT ROW
-| ROW preceding-row
-| ROW BETWEEN preceding-row AND preceding-row
-| ROW BETWEEN preceding-row AND CURRENT ROW
-| ROW BETWEEN preceding-row AND following-row
-| ROW BETWEEN CURRENT ROW AND CURRENT ROW
-| ROW BETWEEN CURRENT ROW AND following-row
-| ROW BETWEEN following-row AND following-row
-```
-
-* `_preceding-row_` is:
-+
-```
- UNBOUNDED PRECEDING
-| unsigned-integer PRECEDING
-```
-
-* `_following-row_` is:
-```
- UNBOUNDED FOLLOWING
-| unsigned-integer FOLLOWING
-```
-
-* `ALL`
-+
-specifies whether duplicate values are included in the computation of
-the COUNT of the _expression_. The default option is ALL, which causes
-duplicate values to be included.
-
-<<<
-* `_expression_`
-+
-specifies a value _expression_ that is to be counted. See
-<<expressions,Expressions>>.
-
-* `_inline-window-specification_`
-+
-specifies the window over which the COUNT is computed. The
-_inline-window-specification_ can contain an optional PARTITION BY
-clause, an optional ORDER BY clause and an optional window frame clause.
-The PARTITION BY clause specifies how the intermediate result is
-partitioned and the ORDER BY clause specifies how the rows are ordered
-within each partition.
-
-* `_window-frame-clause_`
-+
-specifies the window within the partition over which the COUNT is
-computed.
-
-<<<
-[[examples_of_count_window_function]]
-=== Examples of COUNT Window Function
-
-* Return the running count of the SALARY column:
-+
-```
-SELECT
- empnum
-, COUNT(salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the running count of the SALARY column within each department:
-+
-```
-SELECT
- deptnum
-, empnum
-, COUNT(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the moving count of salary within each department over a window
-of the last 4 rows:
-+
-```
-SELECT
- deptnum
-, empnum
-, COUNT(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the running count of employees within each department:
-+
-```
-SELECT
- deptnum
-, empnum
-, COUNT(*) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-
-<<<
-[[dense_rank_window_function]]
-== DENSE_RANK Window Function
-
-DENSE_RANK is a window function that returns the ranking of each row of
-the current partition specified by the inline-window-specification. The
-ranking is relative to the ordering specified in the
-inline-window-specification. The return value of DENSE_RANK starts at 1
-for the first row of the window. Values of the given expression that are
-equal have the same rank. The value of DENSE_RANK advances 1 when the
-value of the given expression changes.
-
-```
-DENSE_RANK() OVER (inline-window-specification)
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-```
-
-* `_inline-window-specification_`
-+
-specifies the window over which the DENSE_RANK is computed. The
-_inline-window-specification_ can contain an optional PARTITION BY
-clause and an optional ORDER BY clause. The PARTITION BY clause
-specifies how the intermediate result is partitioned and the ORDER BY
-clause specifies how the rows are ordered within each partition.
-
-[[examples_of_dense_rank_window_function]]
-=== Examples of DENSE_RANK Window Function
-
-* Return the dense rank for each employee based on employee number:
-+
-```
-SELECT
- DENSE_RANK() OVER (ORDER BY empnum)
-, *
-FROM persnl.employee;
-```
-
-* Return the dense rank for each employee within each department based
-on salary:
-+
-```
-SELECT
- DENSE_RANK() OVER (PARTITION BY deptnum ORDER BY salary)
-, *
-FROM persnl.employee;
-```
-
-<<<
-[[max_window_function]]
-=== MAX Window Function
-
-MAX is a window function that returns the maximum value of all non null
-values of the given expression for the current window specified by the
-inline-window-specification.
-
-```
-MAX ([ALL] expression) OVER (inline-window-specification)
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-[ window-frame-clause ]
-```
-
-* `_window-frame-clause_` is:
-+
-```
- ROWS CURRENT ROW
-| ROWS preceding-row
-| ROWS BETWEEN preceding-row AND preceding-row
-| ROWS BETWEEN preceding-row AND CURRENT ROW
-| ROWS BETWEEN preceding-row AND following-row
-| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
-| ROWS BETWEEN CURRENT ROW AND following-row
-| ROWS BETWEEN following-row AND following-row
-```
-
-* `_preceding-row_` is:
-+
-```
- UNBOUNDED PRECEDING
-| unsigned-integer PRECEDING
-```
-
-* `_following-row_` is:
-+
-```
- UNBOUNDED FOLLOWING
-| unsigned-integer FOLLOWING
-```
-
-* `ALL`
-+
-specifies whether duplicate values are included in the computation of
-the MAX of the _expression_. The default option is ALL, which causes
-duplicate values to be included.
-
-<<<
-* `_expression_`
-+
-specifies an expression that determines the values over which the MAX is
-computed. See <<expressions,Expressions>>.
-
-* `_inline-window-specification_`
-+
-specifies the window over which the MAX is computed. The
-_inline-window-specification_ can contain an optional PARTITION BY
-clause, an optional ORDER BY clause and an optional window frame clause.
-The PARTITION BY clause specifies how the intermediate result is
-partitioned and the ORDER BY clause specifies how the rows are ordered
-within each partition.
-
-* `_window-frame-clause_`
-+
-specifies the window within the partition over which the MAX is
-computed.
-
-<<<
-[[examples_of_max_window_function]]
-=== Examples of MAX Window Function
-
-* Return the running maximum of the SALARY column:
-+
-```
-SELECT
- empnum
-, MAX(salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the running maximum of the SALARY column within each department:
-+
-```
-SELECT
- deptnum
-, empnum, MAX(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the moving maximum of salary within each department over a window of the last 4 rows:
-+
-```
-SELECT
- deptnum
-, empnum
-, MAX(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
-FROM persnl.employee;
-```
-
-<<<
-[[min_window_function]]
-== MIN Window Function
-
-MIN is a window function that returns the minimum value of all non null
-values of the given expression for the current window specified by the
-inline-window-specification.
-
-```
-MIN ([ALL] expression) OVER (inline-window-specification)
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-[ window-frame-clause ]
-```
-
-* `_window-frame-clause_` is:
-+
-```
- ROWS CURRENT ROW
-| ROWS preceding-row
-| ROWS BETWEEN preceding-row AND preceding-row
-| ROWS BETWEEN preceding-row AND CURRENT ROW
-| ROWS BETWEEN preceding-row AND following-row
-| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
-| ROWS BETWEEN CURRENT ROW AND following-row
-| ROWS BETWEEN following-row AND following-row
-```
-
-* `_preceding-row_` is:
-+
-```
- UNBOUNDED PRECEDING
-| unsigned-integer PRECEDING
-```
-
-* `_following-row_` is:
-+
-```
- UNBOUNDED FOLLOWING
-| unsigned-integer FOLLOWING
-```
-
-* `ALL1
-+
-specifies whether duplicate values are included in the computation of
-the MIN of the _expression_. The default option is ALL, which causes
-duplicate values to be included.
-
-<<<
-* `_expression_`
-+
-specifies an expression that determines the values over which the MIN is
-computed See <<expressions,Expressions>>.
-
-* `_inline-window-specification_`
-+
-specifies the window over which the MIN is computed. The
-_inline-window-specification_ can contain an optional PARTITION BY
-clause, an optional ORDER BY clause and an optional window frame clause.
-The PARTITION BY clause specifies how the intermediate result is
-partitioned and the ORDER BY clause specifies how the rows are ordered
-within each partition.
-
-* `_window-frame-clause_`
-+
-specifies the window within the partition over which the MIN is
-computed.
-
-<<<
-[[examples_of_min_window_function]]
-=== Examples of MIN Window Function
-
-* Return the running minimum of the SALARY column:
-+
-```
-SELECT
- empnum
-, MIN(salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the running minimum of the SALARY column within each department:
-+
-```
-SELECT
- deptnum
-, empnum
-, MIN(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the moving minimum of salary within each department over a window of the last 4 rows:
-+
-```
-SELECT
- deptnum
-, empnum
-, MIN(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
-FROM persnl.employee;
-```
-
-<<<
-[[rank_window_function]]
-== RANK Window Function
-
-RANK is a window function that returns the ranking of each row of the
-current partition specified by the inline-window-specification. The
-ranking is relative to the ordering specified in the
-_inline-window-specification_. The return value of RANK starts at 1 for
-the first row of the window. Values that are equal have the same rank.
-The value of RANK advances to the relative position of the row in the
-window when the value changes.
-
-```
-RANK() OVER (inline-window-specification)
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-```
-
-* `_inline-window-specification_`
-+
-specifies the window over which the RANK is computed. The
-_inline-window-specification_ can contain an optional PARTITION BY
-clause and an optional ORDER BY clause. The PARTITION BY clause
-specifies how the intermediate result is partitioned and the ORDER BY
-clause specifies how the rows are ordered within each partition.
-
-[[examples_of_rank_window_function]]
-=== Examples of RANK Window Function
-
-* Return the rank for each employee based on employee number:
-+
-```
-SELECT
- RANK() OVER (ORDER BY empnum)
-, *
-FROM persnl.employee;
-```
-
-* Return the rank for each employee within each department based on salary:
-+
-```
-SELECT
- RANK() OVER (PARTITION BY deptnum ORDER BY salary)
-, *
-FROM persnl.employee;
-```
-
-<<<
-[[row_number_window_function]]
-=== ROW_NUMBER Window Function
-
-ROW_NUMBER is a window function that returns the row number of each row
-of the current window specified by the inline-window-specification.
-
-```
-ROW_NUMBER () OVER (inline-window-specification)
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-```
-
-* `_inline-window-specification_`
-+
-specifies the window over which the ROW_NUMBER is computed. The
-_inline-window-specification_ can contain an optional PARTITION BY
-clause and an optional ORDER BY clause. The PARTITION BY clause
-specifies how the intermediate result is partitioned and the ORDER BY
-clause specifies how the rows are ordered within each partition.
-
-* `_window-frame-clause_`
-+
-specifies the window within the partition over which the ROW_NUMBER is
-computed.
-
-[[examples_of_row_number_window_function]]
-=== Examples of ROW_NUMBER Window Function
-
-* Return the row number for each row of the employee table:
-+
-```
-SELECT
- ROW_NUMBER () OVER(ORDER BY empnum)
-, *
-FROM persnl.employee;
-```
-
-* Return the row number for each row within each department:
-+
-```
-SELECT
- ROW_NUMBER () OVER(PARTITION BY deptnum ORDER BY empnum)
-, *
-FROM persnl.employee;
-```
-
-<<<
-[[stddev_window_function]]
-=== STDDEV Window Function
-
-STDDEV is a window function that returns the standard deviation of non
-null values of the given expression for the current window specified by
-the inline-window-specification.
-
-```
-STDDEV ([ALL] expression) OVER (inline-window-specification)
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-[ window-frame-clause ]
-```
-
-* `_window-frame-clause_` is:
-+
-```
- ROWS CURRENT ROW
-| ROWS preceding-row
-| ROWS BETWEEN preceding-row AND preceding-row
-| ROWS BETWEEN preceding-row AND CURRENT ROW
-| ROWS BETWEEN preceding-row AND following-row
-| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
-| ROWS BETWEEN CURRENT ROW AND following-row
-| ROWS BETWEEN following-row AND following-row
-```
-
-* `_preceding-row_` is:
-+
-```
- UNBOUNDED PRECEDING
-| unsigned-integer PRECEDING
-```
-
-* `_following-row_` is:
-+
-```
- UNBOUNDED FOLLOWING
-| unsigned-integer FOLLOWING
-```
-
-<<<
-* `ALL`
-+
-specifies whether duplicate values are included in the computation of
-the STDDEV of the _expression_. The default option is ALL, which causes
-duplicate values to be included.
-
-* `_expression_`
-+
-specifies a numeric or interval value _expression_ that determines the
-values over which STDDEV is computed.
-
-* `_inline-window-specification_`
-+
-specifies the window over which the STDDEV is computed. The
-_inline-window-specification_ can contain an optional PARTITION BY
-clause, an optional ORDER BY clause and an optional window frame clause.
-The PARTITION BY clause specifies how the intermediate result is
-partitioned and the ORDER BY clause specifies how the rows are ordered
-within each partition.
-
-* `_window-frame-clause_`
-+
-specifies the window within the partition over which the STDDEV is
-computed.
-
-[[examples_of_stddev]]
-=== Examples of STDDEV
-
-* Return the standard deviation of the salary for each row of the
-employee table:
-+
-```
-SELECT
- STDDEV(salary) OVER(ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-, *
-FROM persnl.employee;
-```
-
-* Return the standard deviation for each row within each department:
-+
-```
-SELECT
- STDDEV() OVER(PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-, *
-FROM persnl.employee;
-```
-
-<<<
-[[sum_window_function]]
-== SUM Window Function
-
-SUM is a window function that returns the sum of non null values of the
-given expression for the current window specified by the
-inline-window-specification.
-
-```
-SUM ([ALL] expression) OVER (inline-window-specification)
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-[ window-frame-clause ]
-```
-
-* `_window-frame-clause_` is:
-+
-```
- ROWS CURRENT ROW
-| ROWS preceding-row
-| ROWS BETWEEN preceding-row AND preceding-row
-| ROWS BETWEEN preceding-row AND CURRENT ROW
-| ROWS BETWEEN preceding-row AND following-row
-| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
-| ROWS BETWEEN CURRENT ROW AND following-row
-| ROWS BETWEEN following-row AND following-row
-```
-* `_preceding-row_` is:
-+
-```
- UNBOUNDED PRECEDING
-| unsigned-integer PRECEDING
-```
-
-* `_following-row_` is:
-+
-```
- UNBOUNDED FOLLOWING
-| unsigned-integer FOLLOWING
-```
-
-<<<
-* `ALL`
-+
-specifies whether duplicate values are included in the computation of
-the SUM of the _expression_. The default option is ALL, which causes
-duplicate values to be included.
-
-* `_expression_`
-+
-specifies a numeric or interval value expression that determines the
-values to sum. See <<expressions,Expressions>>.
-
-* `_inline-window-specification_`
-+
-specifies the window over which the SUM is computed. The
-_inline-window-specification_ can contain an optional PARTITION BY
-clause, an optional ORDER BY clause and an optional window frame clause.
-The PARTITION BY clause specifies how the intermediate result is
-partitioned and the ORDER BY clause specifies how the rows are ordered
-within each partition.
-
-* `_window-frame-clause_`
-+
-specifies the window within the partition over which the SUM is computed.
-
-<<<
-[[examples_of_sum_window_function]]
-=== Examples of SUM Window Function
-
-* Return the running sum value of the SALARY column:
-+
-```
-SELECT
- empnum
-, SUM (salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the running sum of the SALARY column within each department:
-+
-```
-SELECT
- deptnum
-, empnum, SUM (salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the moving sum of the SALARY column within each department over a window of the last 4 rows:
-+
-```
-SELECT
- deptnum
-, empnum
-, SUM (salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
-FROM persnl.employee;
-```
-
-<<<
-[[variance_window_function]]
-== VARIANCE Window Function
-
-VARIANCE is a window function that returns the variance of non null
-values of the given expression for the current window specified by the
-inline-window-specification.
-
-```
-VARIANCE ([ALL] expression) OVER (inline-window-specification)
-```
-
-* `_inline-window-specification_` is:
-+
-```
-[PARTITION BY expression [, expression]...]
-[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
- [,expression [ASC[ENDING] | DESC[ENDING]]]...]
-[ window-frame-clause ]
-```
-* `_window-frame-clause_` is:
-+
-```
- ROWS CURRENT ROW
-| ROWS preceding-row
-| ROWS BETWEEN preceding-row AND preceding-row
-| ROWS BETWEEN preceding-row AND CURRENT ROW
-| ROWS BETWEEN preceding-row AND following-row
-| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
-| ROWS BETWEEN CURRENT ROW AND following-row
-| ROWS BETWEEN following-row AND following-row
-```
-
-* `_preceding-row_` is:
-+
-```
- UNBOUNDED PRECEDING
-| unsigned-integer PRECEDING
-```
-
-* `_following-row_` is:
-+
-```
- UNBOUNDED FOLLOWING
-| unsigned-integer FOLLOWING
-```
-
-<<<
-* `ALL`
-+
-specifies whether duplicate values are included in the computation of
-the VARIANCE of the _expression_. The default option is ALL, which causes
-duplicate values to be included.
-
-* `_expression_`
-+
-specifies a numeric or interval value expression that determines the
-values over which the variance is computed.
-See <<expressions,Expressions>>.
-
-* `_inline-window-specification_`
-+
-specifies the window over which the VARIANCE is computed. The
-_inline-window-specification_ can contain an optional PARTITION BY
-clause, an optional ORDER BY clause and an optional window frame clause.
-The PARTITION BY clause specifies how the intermediate result is
-partitioned and the ORDER BY clause specifies how the rows are ordered
-within each partition.
-
-* `_window-frame-clause_`
-+
-specifies the window within the partition over which the VARIANCE is
-computed.
-
-[[examples_of_variance_window_function]]
-=== Examples of VARIANCE Window Function
-
-* Return the variance of the SALARY column:
-+
-```
-SELECT
- empnum
-, VARIANCE (salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-* Return the variance of the SALARY column within each department:
-+
-```
-SELECT
- deptnum
-, empnum
-, VARIANCE (salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
-FROM persnl.employee;
-```
-
-
+////
+/**
+* @@@ START COPYRIGHT @@@
+*
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing,
+* software distributed under the License is distributed on an
+* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+* KIND, either express or implied. See the License for the
+* specific language governing permissions and limitations
+* under the License.
+*
+* @@@ END COPYRIGHT @@@
+*/
+////
+
+[[olap_functions]]
+= OLAP Functions
+
+This section describes the syntax and semantics of the On Line
+Analytical Process (OLAP) window functions. The OLAP window functions
+are ANSI compliant.
+
+[[considerations_for_window_functions]]
+== Considerations for Window Functions
+
+These considerations apply to all window functions.
+
+* `_inline-window-specification_`
++
+The window defined by the _inline-window-specification_ consists of the
+rows specified by the _window-frame-clause_, bounded by the current
+partition. If no PARTITION BY clause is specified, the partition is
+defined to be all the rows of the intermediate result. If a PARTITION BY
+clause is specified, the partition is the set of rows which have the
+same values for the expressions specified in the PARTITION clause.
+
+* `_window-frame-clause_`
++
+DISTINCT is not supported for window functions.
++
+Use of a FOLLOWING term is not supported. Using a FOLLOWING term results
+in an error.
++
+If no _window-frame-clause_ is specified, "ROWS BETWEEN UNBOUNDED
+PRECEDING AND UNBOUNDED FOLLOWING" is assumed. This clause is not
+supported because it involves a FOLLOWING term and will result in an
+error.
++
+"ROWS CURRENT ROW" is equivalent to "ROWS BETWEEN CURRENT ROW AND
+CURRENT ROW".
++
+"ROWS _preceding-row_" is equivalent to "ROWS BETWEEN _preceding-row_
+AND CURRENT ROW".
+
+=== Nulls
+
+All nulls are eliminated before the function is applied to the set of
+values. If the window contains all NULL values, the result of the window
+function is NULL.
+
+If the specified window for a particular row consists of rows that are
+all before the first row of the partition (no rows in the window), the
+result of the window function is NULL.
+
+<<<
+[[order_by_clause_supports_expressions_for_olap_functions]]
+== ORDER BY Clause Supports Expressions For OLAP Functions
+
+The ORDER BY clause of the OLAP functions now supports expressions.
+However, use of multiple OLAP functions with different expressions in
+the same query is not supported. The following examples show how
+expressions may be used in the ORDER BY clause.
+
+```
+SELECT
+ -1 * annualsalary neg_total
+, RANK() OVER (ORDER BY -1 * annualsalary) olap_rank
+FROM employee;
+```
+
+Using an aggregate in the ORDER BY clause:
+
+```
+SELECT
+ num
+, RANK() OVER (ORDER BY SUM(annualsalary)) olap_rank
+FROM employee
+GROUP BY num;
+```
+
+Using multiple functions with the same expression in the ORDER BY clause:
+
+```
+SELECT
+ num
+, workgroupnum
+, RANK() OVER (ORDER BY SUM (annualsalary)*num) olap_rank
+, DENSE_RANK() OVER (ORDER BY SUM (annualsalary)*num) olap_drank
+, ROW_NUMBER() OVER (ORDER BY SUM (annualsalary)*num) olap_mum
+FROM employee
+GROUP BY num, workgroupnum, annualsalary;
+```
+
+Using more functions with the same expression in the ORDER BY clause:
+
+```
+SELECT
+ num
+, workgroupnum
+, annualsalary
+, SUM(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
+, AVG(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
+, MIN(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
+, MAX(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
+, VARIANCE(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
+, STDDEV(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
+, COUNT(AnnualSalary) OVER (ORDER BY SUM(annualsalary)*num ROWS UNBOUNDED PRECEDING)
+FROM employee
+GROUP BY num, workgroupnum, annualsalary;
+```
+
+<<<
+[[limitations_for_window_functions]]
+== Limitations for Window Functions
+
+These limitations apply to all window functions.
+
+* The ANSI _window-clause_ is not supported by {project-name}. Only the
+_inline-window-specification_ is supported. An attempt to use an ANSI
+_window-clause_ will result in a syntax error.
+
+* The _window-frame-clause_ cannot contain a FOLLOWING term, either
+explicitly or implicitly. Because the default window frame clause
+contains an implicit FOLLOWING ("ROWS BETWEEN UNBOUNDED PRECEDING AND
+UNBOUNDED FOLLOWING"), the default is not supported. So, practically,
+the _window-frame-clause_ is not optional. An attempt to use a FOLLOWING
+term, either explicitly or implicitly will result in the "4343" error
+message.
+
+* The window frame units can only be ROWS. RANGE is not supported by
+{project-name}. An attempt to use RANGE will result in a syntax error.
+
+* The ANSI _window-frame-exclusion-specification_ is not supported by
+{project-name}. An attempt to use a _window-frame-exclusion-specification_
+will result in a syntax error.
+
+* Multiple _inline-window-specifications_ in a single SELECT clause are
+not supported. For each window function within a SELECT clause, the
+ORDER BY clause and PARTITION BY specifications must be identical. The
+window frame can vary within a SELECT clause. An attempt to use multiple
+_inline-window-specifications_ in a single SELECT clause will result in
+the "4340" error message.
+
+* The ANSI _null-ordering-specification_ within the ORDER BY clause is
+not supported by {project-name}. Null values will always be sorted as if they
+are greater than all non-null values. This is slightly different than a
+null ordering of NULLS LAST. An attempt to use a
+_null-ordering-specification_ will result in a syntax error.
+
+* The ANSI _filter-clause_ is not supported for window functions by
+{project-name}. The _filter-clause_ applies to all aggregate functions
+(grouped and windowed) and that the _filter-clause_ is not currently
+supported for grouped aggregate functions. An attempt to use a
+_filter-clause_ will result in a syntax error.
+
+* The DISTINCT value for the _set-qualifier-clause_ within a window
+function is not supported. Only the ALL value is supported for the
+_set-qualifier-clause_ within a window function. An attempt to use
+DISTINCT in a window function will result in the "4341" error message.
+
+<<<
+[[avg_window_function]]
+== AVG Window Function
+
+AVG is a window function that returns the average of non-null values of
+the given expression for the current window specified by the
+_inline-window specification_.
+
+```
+AVG ([ALL] expression) OVER (inline-window-specification)
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+[ window-frame-clause ]
+```
+
+* `_window-frame-clause_` is:
++
+```
+ ROWS CURRENT ROW
+| ROWS preceding-row
+| ROWS BETWEEN preceding-row AND preceding-row
+| ROWS BETWEEN preceding-row AND CURRENT ROW
+| ROWS BETWEEN preceding-row AND following-row
+| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
+| ROWS BETWEEN CURRENT ROW AND following-row
+| ROWS BETWEEN following-row AND following-row
+```
+
+* `_preceding-row_` is:
++
+```
+ UNBOUNDED PRECEDING
+| unsigned-integer PRECEDING
+```
+
+* `_following-row_` is:
++
+```
+ UNBOUNDED FOLLOWING
+| unsigned-integer FOLLOWING
+```
+
+<<<
+* `ALL`
++
+specifies whether duplicate values are included in the computation of
+the AVG of the _expression_. The default option is ALL, which causes
+duplicate values to be included.
+
+* `_expression_`
++
+specifies a numeric or interval value _expression_ that determines the
+values to average. See <<numeric_value_expressions,Numeric Value Expressions>>
+and <<interval_value_expressions,Interval Value Expressions>>.
+
+* `_inline-window-specification_`
++
+specifies_the_window_over_which_the_avg_is_computed. The
+_inline-window-specification_ can contain an optional partition by
+clause, an optional ORDER BY clause and an optional window frame clause.
+The PARTITION BY clause specifies how the intermediate result is
+partitioned and the ORDER BY clause specifies how the rows are ordered
+within each partition.
+
+* `_window-frame-clause_`
++
+specifies the window within the partition over which the AVG is
+computed.
+
+<<<
+[[examples_of_avg_window_function]]
+=== Examples of AVG Window Function
+
+* Return the running average value of the SALARY column:
++
+```
+SELECT
+ empnum
+, AVG(salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the running average value of the SALARY column within each
+department:
++
+```
+SELECT
+ deptnum
+, empnum
+, AVG(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the moving average of salary within each department over a
+window of the last 4 rows:
++
+```
+SELECT
+ deptnum
+, empnum
+, AVG(SALARY) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
+FROM persnl.employee;
+```
+
+<<<
+[[count_window_function]]
+== COUNT Window Function
+
+COUNT is a window function that returns the count of the non null values
+of the given expression for the current window specified by the
+inline-window-specification.
+
+```
+COUNT {(*) | ([ALL] expression) } OVER inline-window-specification
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+[ window-frame-clause ]
+```
+
+* `_window-frame-clause_` is:
++
+```
+ ROW CURRENT ROW
+| ROW preceding-row
+| ROW BETWEEN preceding-row AND preceding-row
+| ROW BETWEEN preceding-row AND CURRENT ROW
+| ROW BETWEEN preceding-row AND following-row
+| ROW BETWEEN CURRENT ROW AND CURRENT ROW
+| ROW BETWEEN CURRENT ROW AND following-row
+| ROW BETWEEN following-row AND following-row
+```
+
+* `_preceding-row_` is:
++
+```
+ UNBOUNDED PRECEDING
+| unsigned-integer PRECEDING
+```
+
+* `_following-row_` is:
+```
+ UNBOUNDED FOLLOWING
+| unsigned-integer FOLLOWING
+```
+
+* `ALL`
++
+specifies whether duplicate values are included in the computation of
+the COUNT of the _expression_. The default option is ALL, which causes
+duplicate values to be included.
+
+<<<
+* `_expression_`
++
+specifies a value _expression_ that is to be counted. See
+<<expressions,Expressions>>.
+
+* `_inline-window-specification_`
++
+specifies the window over which the COUNT is computed. The
+_inline-window-specification_ can contain an optional PARTITION BY
+clause, an optional ORDER BY clause and an optional window frame clause.
+The PARTITION BY clause specifies how the intermediate result is
+partitioned and the ORDER BY clause specifies how the rows are ordered
+within each partition.
+
+* `_window-frame-clause_`
++
+specifies the window within the partition over which the COUNT is
+computed.
+
+<<<
+[[examples_of_count_window_function]]
+=== Examples of COUNT Window Function
+
+* Return the running count of the SALARY column:
++
+```
+SELECT
+ empnum
+, COUNT(salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the running count of the SALARY column within each department:
++
+```
+SELECT
+ deptnum
+, empnum
+, COUNT(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the moving count of salary within each department over a window
+of the last 4 rows:
++
+```
+SELECT
+ deptnum
+, empnum
+, COUNT(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the running count of employees within each department:
++
+```
+SELECT
+ deptnum
+, empnum
+, COUNT(*) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+
+<<<
+[[dense_rank_window_function]]
+== DENSE_RANK Window Function
+
+DENSE_RANK is a window function that returns the ranking of each row of
+the current partition specified by the inline-window-specification. The
+ranking is relative to the ordering specified in the
+inline-window-specification. The return value of DENSE_RANK starts at 1
+for the first row of the window. Values of the given expression that are
+equal have the same rank. The value of DENSE_RANK advances 1 when the
+value of the given expression changes.
+
+```
+DENSE_RANK() OVER (inline-window-specification)
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+```
+
+* `_inline-window-specification_`
++
+specifies the window over which the DENSE_RANK is computed. The
+_inline-window-specification_ can contain an optional PARTITION BY
+clause and an optional ORDER BY clause. The PARTITION BY clause
+specifies how the intermediate result is partitioned and the ORDER BY
+clause specifies how the rows are ordered within each partition.
+
+[[examples_of_dense_rank_window_function]]
+=== Examples of DENSE_RANK Window Function
+
+* Return the dense rank for each employee based on employee number:
++
+```
+SELECT
+ DENSE_RANK() OVER (ORDER BY empnum)
+, *
+FROM persnl.employee;
+```
+
+* Return the dense rank for each employee within each department based
+on salary:
++
+```
+SELECT
+ DENSE_RANK() OVER (PARTITION BY deptnum ORDER BY salary)
+, *
+FROM persnl.employee;
+```
+
+<<<
+[[max_window_function]]
+=== MAX Window Function
+
+MAX is a window function that returns the maximum value of all non null
+values of the given expression for the current window specified by the
+inline-window-specification.
+
+```
+MAX ([ALL] expression) OVER (inline-window-specification)
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+[ window-frame-clause ]
+```
+
+* `_window-frame-clause_` is:
++
+```
+ ROWS CURRENT ROW
+| ROWS preceding-row
+| ROWS BETWEEN preceding-row AND preceding-row
+| ROWS BETWEEN preceding-row AND CURRENT ROW
+| ROWS BETWEEN preceding-row AND following-row
+| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
+| ROWS BETWEEN CURRENT ROW AND following-row
+| ROWS BETWEEN following-row AND following-row
+```
+
+* `_preceding-row_` is:
++
+```
+ UNBOUNDED PRECEDING
+| unsigned-integer PRECEDING
+```
+
+* `_following-row_` is:
++
+```
+ UNBOUNDED FOLLOWING
+| unsigned-integer FOLLOWING
+```
+
+* `ALL`
++
+specifies whether duplicate values are included in the computation of
+the MAX of the _expression_. The default option is ALL, which causes
+duplicate values to be included.
+
+<<<
+* `_expression_`
++
+specifies an expression that determines the values over which the MAX is
+computed. See <<expressions,Expressions>>.
+
+* `_inline-window-specification_`
++
+specifies the window over which the MAX is computed. The
+_inline-window-specification_ can contain an optional PARTITION BY
+clause, an optional ORDER BY clause and an optional window frame clause.
+The PARTITION BY clause specifies how the intermediate result is
+partitioned and the ORDER BY clause specifies how the rows are ordered
+within each partition.
+
+* `_window-frame-clause_`
++
+specifies the window within the partition over which the MAX is
+computed.
+
+<<<
+[[examples_of_max_window_function]]
+=== Examples of MAX Window Function
+
+* Return the running maximum of the SALARY column:
++
+```
+SELECT
+ empnum
+, MAX(salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the running maximum of the SALARY column within each department:
++
+```
+SELECT
+ deptnum
+, empnum, MAX(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the moving maximum of salary within each department over a window of the last 4 rows:
++
+```
+SELECT
+ deptnum
+, empnum
+, MAX(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
+FROM persnl.employee;
+```
+
+<<<
+[[min_window_function]]
+== MIN Window Function
+
+MIN is a window function that returns the minimum value of all non null
+values of the given expression for the current window specified by the
+inline-window-specification.
+
+```
+MIN ([ALL] expression) OVER (inline-window-specification)
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+[ window-frame-clause ]
+```
+
+* `_window-frame-clause_` is:
++
+```
+ ROWS CURRENT ROW
+| ROWS preceding-row
+| ROWS BETWEEN preceding-row AND preceding-row
+| ROWS BETWEEN preceding-row AND CURRENT ROW
+| ROWS BETWEEN preceding-row AND following-row
+| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
+| ROWS BETWEEN CURRENT ROW AND following-row
+| ROWS BETWEEN following-row AND following-row
+```
+
+* `_preceding-row_` is:
++
+```
+ UNBOUNDED PRECEDING
+| unsigned-integer PRECEDING
+```
+
+* `_following-row_` is:
++
+```
+ UNBOUNDED FOLLOWING
+| unsigned-integer FOLLOWING
+```
+
+* `ALL1
++
+specifies whether duplicate values are included in the computation of
+the MIN of the _expression_. The default option is ALL, which causes
+duplicate values to be included.
+
+<<<
+* `_expression_`
++
+specifies an expression that determines the values over which the MIN is
+computed See <<expressions,Expressions>>.
+
+* `_inline-window-specification_`
++
+specifies the window over which the MIN is computed. The
+_inline-window-specification_ can contain an optional PARTITION BY
+clause, an optional ORDER BY clause and an optional window frame clause.
+The PARTITION BY clause specifies how the intermediate result is
+partitioned and the ORDER BY clause specifies how the rows are ordered
+within each partition.
+
+* `_window-frame-clause_`
++
+specifies the window within the partition over which the MIN is
+computed.
+
+<<<
+[[examples_of_min_window_function]]
+=== Examples of MIN Window Function
+
+* Return the running minimum of the SALARY column:
++
+```
+SELECT
+ empnum
+, MIN(salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the running minimum of the SALARY column within each department:
++
+```
+SELECT
+ deptnum
+, empnum
+, MIN(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the moving minimum of salary within each department over a window of the last 4 rows:
++
+```
+SELECT
+ deptnum
+, empnum
+, MIN(salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
+FROM persnl.employee;
+```
+
+<<<
+[[rank_window_function]]
+== RANK Window Function
+
+RANK is a window function that returns the ranking of each row of the
+current partition specified by the inline-window-specification. The
+ranking is relative to the ordering specified in the
+_inline-window-specification_. The return value of RANK starts at 1 for
+the first row of the window. Values that are equal have the same rank.
+The value of RANK advances to the relative position of the row in the
+window when the value changes.
+
+```
+RANK() OVER (inline-window-specification)
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+```
+
+* `_inline-window-specification_`
++
+specifies the window over which the RANK is computed. The
+_inline-window-specification_ can contain an optional PARTITION BY
+clause and an optional ORDER BY clause. The PARTITION BY clause
+specifies how the intermediate result is partitioned and the ORDER BY
+clause specifies how the rows are ordered within each partition.
+
+[[examples_of_rank_window_function]]
+=== Examples of RANK Window Function
+
+* Return the rank for each employee based on employee number:
++
+```
+SELECT
+ RANK() OVER (ORDER BY empnum)
+, *
+FROM persnl.employee;
+```
+
+* Return the rank for each employee within each department based on salary:
++
+```
+SELECT
+ RANK() OVER (PARTITION BY deptnum ORDER BY salary)
+, *
+FROM persnl.employee;
+```
+
+<<<
+[[row_number_window_function]]
+=== ROW_NUMBER Window Function
+
+ROW_NUMBER is a window function that returns the row number of each row
+of the current window specified by the inline-window-specification.
+
+```
+ROW_NUMBER () OVER (inline-window-specification)
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+```
+
+* `_inline-window-specification_`
++
+specifies the window over which the ROW_NUMBER is computed. The
+_inline-window-specification_ can contain an optional PARTITION BY
+clause and an optional ORDER BY clause. The PARTITION BY clause
+specifies how the intermediate result is partitioned and the ORDER BY
+clause specifies how the rows are ordered within each partition.
+
+* `_window-frame-clause_`
++
+specifies the window within the partition over which the ROW_NUMBER is
+computed.
+
+[[examples_of_row_number_window_function]]
+=== Examples of ROW_NUMBER Window Function
+
+* Return the row number for each row of the employee table:
++
+```
+SELECT
+ ROW_NUMBER () OVER(ORDER BY empnum)
+, *
+FROM persnl.employee;
+```
+
+* Return the row number for each row within each department:
++
+```
+SELECT
+ ROW_NUMBER () OVER(PARTITION BY deptnum ORDER BY empnum)
+, *
+FROM persnl.employee;
+```
+
+<<<
+[[stddev_window_function]]
+=== STDDEV Window Function
+
+STDDEV is a window function that returns the standard deviation of non
+null values of the given expression for the current window specified by
+the inline-window-specification.
+
+```
+STDDEV ([ALL] expression) OVER (inline-window-specification)
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+[ window-frame-clause ]
+```
+
+* `_window-frame-clause_` is:
++
+```
+ ROWS CURRENT ROW
+| ROWS preceding-row
+| ROWS BETWEEN preceding-row AND preceding-row
+| ROWS BETWEEN preceding-row AND CURRENT ROW
+| ROWS BETWEEN preceding-row AND following-row
+| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
+| ROWS BETWEEN CURRENT ROW AND following-row
+| ROWS BETWEEN following-row AND following-row
+```
+
+* `_preceding-row_` is:
++
+```
+ UNBOUNDED PRECEDING
+| unsigned-integer PRECEDING
+```
+
+* `_following-row_` is:
++
+```
+ UNBOUNDED FOLLOWING
+| unsigned-integer FOLLOWING
+```
+
+<<<
+* `ALL`
++
+specifies whether duplicate values are included in the computation of
+the STDDEV of the _expression_. The default option is ALL, which causes
+duplicate values to be included.
+
+* `_expression_`
++
+specifies a numeric or interval value _expression_ that determines the
+values over which STDDEV is computed.
+
+* `_inline-window-specification_`
++
+specifies the window over which the STDDEV is computed. The
+_inline-window-specification_ can contain an optional PARTITION BY
+clause, an optional ORDER BY clause and an optional window frame clause.
+The PARTITION BY clause specifies how the intermediate result is
+partitioned and the ORDER BY clause specifies how the rows are ordered
+within each partition.
+
+* `_window-frame-clause_`
++
+specifies the window within the partition over which the STDDEV is
+computed.
+
+[[examples_of_stddev]]
+=== Examples of STDDEV
+
+* Return the standard deviation of the salary for each row of the
+employee table:
++
+```
+SELECT
+ STDDEV(salary) OVER(ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+, *
+FROM persnl.employee;
+```
+
+* Return the standard deviation for each row within each department:
++
+```
+SELECT
+ STDDEV() OVER(PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+, *
+FROM persnl.employee;
+```
+
+<<<
+[[sum_window_function]]
+== SUM Window Function
+
+SUM is a window function that returns the sum of non null values of the
+given expression for the current window specified by the
+inline-window-specification.
+
+```
+SUM ([ALL] expression) OVER (inline-window-specification)
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+[ window-frame-clause ]
+```
+
+* `_window-frame-clause_` is:
++
+```
+ ROWS CURRENT ROW
+| ROWS preceding-row
+| ROWS BETWEEN preceding-row AND preceding-row
+| ROWS BETWEEN preceding-row AND CURRENT ROW
+| ROWS BETWEEN preceding-row AND following-row
+| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
+| ROWS BETWEEN CURRENT ROW AND following-row
+| ROWS BETWEEN following-row AND following-row
+```
+* `_preceding-row_` is:
++
+```
+ UNBOUNDED PRECEDING
+| unsigned-integer PRECEDING
+```
+
+* `_following-row_` is:
++
+```
+ UNBOUNDED FOLLOWING
+| unsigned-integer FOLLOWING
+```
+
+<<<
+* `ALL`
++
+specifies whether duplicate values are included in the computation of
+the SUM of the _expression_. The default option is ALL, which causes
+duplicate values to be included.
+
+* `_expression_`
++
+specifies a numeric or interval value expression that determines the
+values to sum. See <<expressions,Expressions>>.
+
+* `_inline-window-specification_`
++
+specifies the window over which the SUM is computed. The
+_inline-window-specification_ can contain an optional PARTITION BY
+clause, an optional ORDER BY clause and an optional window frame clause.
+The PARTITION BY clause specifies how the intermediate result is
+partitioned and the ORDER BY clause specifies how the rows are ordered
+within each partition.
+
+* `_window-frame-clause_`
++
+specifies the window within the partition over which the SUM is computed.
+
+<<<
+[[examples_of_sum_window_function]]
+=== Examples of SUM Window Function
+
+* Return the running sum value of the SALARY column:
++
+```
+SELECT
+ empnum
+, SUM (salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the running sum of the SALARY column within each department:
++
+```
+SELECT
+ deptnum
+, empnum, SUM (salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the moving sum of the SALARY column within each department over a window of the last 4 rows:
++
+```
+SELECT
+ deptnum
+, empnum
+, SUM (salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS 3 PRECEDING)
+FROM persnl.employee;
+```
+
+<<<
+[[variance_window_function]]
+== VARIANCE Window Function
+
+VARIANCE is a window function that returns the variance of non null
+values of the given expression for the current window specified by the
+inline-window-specification.
+
+```
+VARIANCE ([ALL] expression) OVER (inline-window-specification)
+```
+
+* `_inline-window-specification_` is:
++
+```
+[PARTITION BY expression [, expression]...]
+[ORDER BY expression [ASC[ENDING] | DESC[ENDING]]
+ [,expression [ASC[ENDING] | DESC[ENDING]]]...]
+[ window-frame-clause ]
+```
+* `_window-frame-clause_` is:
++
+```
+ ROWS CURRENT ROW
+| ROWS preceding-row
+| ROWS BETWEEN preceding-row AND preceding-row
+| ROWS BETWEEN preceding-row AND CURRENT ROW
+| ROWS BETWEEN preceding-row AND following-row
+| ROWS BETWEEN CURRENT ROW AND CURRENT ROW
+| ROWS BETWEEN CURRENT ROW AND following-row
+| ROWS BETWEEN following-row AND following-row
+```
+
+* `_preceding-row_` is:
++
+```
+ UNBOUNDED PRECEDING
+| unsigned-integer PRECEDING
+```
+
+* `_following-row_` is:
++
+```
+ UNBOUNDED FOLLOWING
+| unsigned-integer FOLLOWING
+```
+
+<<<
+* `ALL`
++
+specifies whether duplicate values are included in the computation of
+the VARIANCE of the _expression_. The default option is ALL, which causes
+duplicate values to be included.
+
+* `_expression_`
++
+specifies a numeric or interval value expression that determines the
+values over which the variance is computed.
+See <<expressions,Expressions>>.
+
+* `_inline-window-specification_`
++
+specifies the window over which the VARIANCE is computed. The
+_inline-window-specification_ can contain an optional PARTITION BY
+clause, an optional ORDER BY clause and an optional window frame clause.
+The PARTITION BY clause specifies how the intermediate result is
+partitioned and the ORDER BY clause specifies how the rows are ordered
+within each partition.
+
+* `_window-frame-clause_`
++
+specifies the window within the partition over which the VARIANCE is
+computed.
+
+[[examples_of_variance_window_function]]
+=== Examples of VARIANCE Window Function
+
+* Return the variance of the SALARY column:
++
+```
+SELECT
+ empnum
+, VARIANCE (salary) OVER (ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+* Return the variance of the SALARY column within each department:
++
+```
+SELECT
+ deptnum
+, empnum
+, VARIANCE (salary) OVER (PARTITION BY deptnum ORDER BY empnum ROWS UNBOUNDED PRECEDING)
+FROM persnl.employee;
+```
+
+
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/da748b4d/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc b/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc
index 0362601..0da11ce 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/reserved_words.adoc
@@ -1,286 +1,286 @@
-////
-/**
-* @@@ START COPYRIGHT @@@
-*
-* Licensed to the Apache Software Foundation (ASF) under one
-* or more contributor license agreements. See the NOTICE file
-* distributed with this work for additional information
-* regarding copyright ownership. The ASF licenses this file
-* to you under the Apache License, Version 2.0 (the
-* "License"); you may not use this file except in compliance
-* with the License. You may obtain a copy of the License at
-*
-* http://www.apache.org/licenses/LICENSE-2.0
-*
-* Unless required by applicable law or agreed to in writing,
-* software distributed under the License is distributed on an
-* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-* KIND, either express or implied. See the License for the
-* specific language governing permissions and limitations
-* under the License.
-*
-* @@@ END COPYRIGHT @@@
-*/
-////
-
-[[reserved_words]]
-= Reserved Words
-The words listed in this appendix are reserved for use by {project-name} SQL.
-To prevent syntax errors, avoid using these words as identifiers in
-{project-name} SQL. In {project-name} SQL, if an operating system name contains a
-reserved word, you must enclose the reserved word in double quotes (")
-to access that column or object.
-
-NOTE: In {project-name} SQL, ABSOLUTE, DATA, EVERY, INITIALIZE, OPERATION,
-PATH, SPACE, STATE, STATEMENT, STATIC, and START are not reserved words.
-
-{project-name} SQL treats these words as reserved when they are part of
-{project-name} SQL stored text. They cannot be used as identifiers unless you
-enclose them in double quotes.
-
-[[reserved_sql_identifiers_a]]
-== Reserved SQL Identifiers: A
-
-
-[cols="5*l"]
-|===
-| ACTION | ADD | ADMIN | AFTER | AGGREGATE
-| ALIAS| | ALL | ALLOCATE | ALTER | AND
-| ANY | ARE | ARRAY | AS | ASC
-| ASSERTION| ASYNC | AT | AUTHORIZATION | AVG
-|===
-
-
-[[reserved_sql_identifiers_b]]
-== Reserved SQL Identifiers: B
-
-
-[cols="5*l"]
-|===
-| BEFORE | BEGIN | BETWEEN | BINARY | BIT
-| BIT_LENGTH | BLOB | BOOLEAN | BOTH | BREADTH
-| BY | | | |
-|===
-
-[[reserved_sql_identifiers_c]]
-== Reserved SQL Identifiers: C
-
-
-[cols="5*l"]
-|===
-| CALL | CASCADE | CASCADED | CASE | CAST
-| CATALOG | CHAR | CHARACTER | CHARACTER_LENGTH | CHAR_LENGTH
-| CHECK | CLASS | CLOB | CLOSE | COALESCE
-| COLLATE | COLLATION | COLUMN | COMMIT | COMPLETION
-| CONNECT | CONNECTION | CONSTRAINT | CONSTRAINTS | CONSTRUCTOR
-| CONTINUE | CONVERT | CORRESPONDING | COUNT | CREATE
-| CROSS | CUBE | CURRENT | CURRENT_DATE | CURRENT_PATH
-| CURRENT_ROLE | CURRENT_TIME | CURRENT_TIMESTAMP | CURRENT_USER | CURRNT_USR_INTN
-| CURSOR | CYCLE | | |
-|===
-
-
-[[reserved_sql_identifiers_d]]
-== Reserved SQL Identifiers: D
-
-[cols="5*l"]
-|===
-| DATE | DATETIME | DAY | DEALLOCATE | DEC
-| DECIMAL | DECLARE | DEFAULT | DEFERRABLE | DEFERRED
-| DELETE | DEPTH | DEREF | DESC | DESCRIBE
-| DESCRIPTOR | DESTROY | DESTRUCTOR | DETERMINISTIC | DIAGNOSTICS
-| DICTIONARY | DISCONNECT | DISTINCT | DOMAIN | DOUBLE
-| DROP | DYNAMIC | | |
-|===
-
-
-[[reserved_sql_identifiers_e]]
-== Reserved SQL Identifiers: E
-
-
-[cols="5*l"]
-|===
-| EACH | ELSE | ELSEIF | END | END-EXEC
-| EQUALS | ESCAPE | EXCEPT | EXCEPTION | EXEC
-| EXECUTE | EXISTS | EXTERNAL | EXTRACT |
-|===
-
-
-== Reserved SQL Identifers: F
-
-[cols="5*l"]
-|===
-| FALSE | FETCH | FIRST | FLOAT | FOR
-| FOREIGN | FOUND | FRACTION | FREE | FROM
-| FULL | FUNCTION | | |
-|===
-
-
-[[reserved_sql_identifiers_g]]
-== Reserved SQL Identifiers G
-
-[cols="5*l"]
-|===
-| GENERAL | GET | GLOBAL | GO | GOTO
-| GRANT | GROUP | GROUPING | |
-|===
-
-[[reserved_sql_identifiers_h]]
-== Reserved SQL Identifiers: H
-
-[[reserved_sql_identifiers_i]]
-== Reserved SQL Identifiers: I
-
-
-[cols="5*l"]
-|===
-| IDENTITY | IF | IGNORE | IMMEDIATE | IN
-| INDICATOR | INITIALLY | INNER | INOUT | INPUT
-| INSENSITIVE | INSERT | INT | INTEGER | INTERSECT
-| INTERVAL | INTO | IS | ISOLATION | ITERATE
-|===
-
-
-[[reserved_sql_identifiers_j]]
-== Reserved SQL Identifiers J
-
-[[reserved_sql_identifiers_k]]
-== Reserved SQL Identifiers: K
-
-[[reserved_sql_identifiers_l]]
-== Reserved SQL Identifiers: L
-
-[cols="5*l"]
-|===
-| LANGUAGE | LARGE | LAST | LATERAL | LEADING
-| LEAVE | LEFT | LESS | LEVEL | LIKE
-| LIMIT | LOCAL | LOCALTIME | LOCALTIMESTAMP | LOCATOR
-| LOOP | LOWER | | |
-|===
-
-
-[[reserved_sql_identifiers_m]]
-== Reserved SQL Identifiers: M
-
-[cols="5*l"]
-|===
-| MAINTAIN | MAP | MATCH | MATCHED | MAX
-| MERGE | MIN | MINUTE | MODIFIES | MODIFY
-| MODULE | MONTH | | |
-|===
-
-
-[[reserved_sql_identifiers_n]]
-== Reserved SQL Identifiers: N
-
-[cols="5*l"]
-|===
-| NAMES | NATIONAL | NATURAL | NCHAR | NCLOB
-| NEW | NEXT | NO | NONE | NOT
-| NULL | NULLIF | NUMERIC | |
-|===
-
-[[reserved_sql_identifiers_o]]
-== Reserved SQL Identifiers: O
-
-[cols="5*l"]
-|===
-| OCTET_LENGTH | OF | OFF | OID | OLD
-| ON | ONLY | OPEN | OPERATORS | OPTION
-| OPTIONS | OR | ORDER | ORDINALITY | OTHERS
-| OUT | OUTER | OUTPUT | OVERLAPS |
-|===
-
-
-[[reserved_sql_identifiers_p]]
-== Reserved SQL Identifiers: P
-
-[cols="5*l"]
-|===
-| PAD | PARAMETER | PARAMETERS | PARTIAL | PENDANT
-| POSITION | POSTFIX | PRECISION | PREFIX | PREORDER
-| PREPARE | PRESERVE | PRIMARY | PRIOR | PRIVATE
-| PRIVILEGES | PROCEDURE | PROTECTED | PROTOTYPE | PUBLIC
-|===
-
-
-[[reserved_sql_identifiers_q]]
-== Reserved SQL Identifiers: Q
-
-[[reserved_sql_identifiers_r]]
-== Reserved SQL Identifiers: R
-
-[cols="5*l"]
-|===
-| READ | READS | REAL | RECURSIVE | REF
-| REFERENCES | REFERENCING | RELATIVE | REORG | REORGANIZE
-| REPLACE | RESIGNAL | RESTRICT | RESULT | RETURN
-| RETURNS | REVOKE | RIGHT | ROLLBACK | ROLLUP
-| ROUTINE | ROW | ROWS | |
-|===
-
-[[reserved_sql_identifiers_s]]
-== Reserved SQL Identifiers: S
-
-[cols="5*l"]
-|===
-| SAVEPOINT | SCHEMA | SCOPE | SCROLL | SEARCH
-| SECOND | SECTION | SELECT | SENSITIVE | SESSION
-| SESSION_USER | SESSN_USR_INTN | SET | SETS | SIGNAL
-| SIMILAR | SIZE | SMALLINT | SOME | SPECIFIC
-| SPECIFICTYPE | SQL | SQL_CHAR | SQL_DATE | SQL_DECIMAL
-| SQL_DOUBLE | SQL_FLOAT | SQL_INT | SQL_INTEGER | SQL_REAL
-| SQL_SMALLINT | SQL_TIME | SQL_TIMESTAMP | SQL_VARCHAR | SQLCODE
-| SQLERROR | SQLEXCEPTION | SQLSTATE | SQLWARNING | STRUCTURE
-| SUBSTRING | SUM | SYNONYM | SYSTEM_USER |
-|===
-
-
-[[reserved_sql_identifiers_t]]
-== Reserved SQL Identifiers: T
-
-[cols="5*l"]
-|===
-| TABLE | TEMPORARY | TERMINATE | TEST | THAN
-| THEN | THERE | TIME | TIMESTAMP | TIMEZONE_HOUR
-| TIMEZONE_MINUTE | TO | TRAILING | TRANSACTION | TRANSLATE
-| TRANSLATION | TRANSPOSE | TREAT | TRIGGER | TRIM
-| TRUE | | | |
-|===
-
-[[reserved_sql_identifiers_u]]
-== Reserved SQL Identifiers: U
-
-[cols="5*l"]
-|===
-| UNDER | UNION | UNIQUE | UNKNOWN | UNNEST
-| UPDATE | UPPER | UPSHIFT | USAGE | USER
-| USING | | | |
-|===
-
-[[reserved_sql_identifiers_v]]
-== Reserved SQL Identifiers: V
-
-[cols="5*l"]
-|===
-| VALUE | VALUES | VARCHAR | VARIABLE | VARYING
-| VIEW | VIRTUAL | VISIBLE | |
-|===
-
-[[reserved_sql_identifiers_w]]
-== Reserved SQL Identifiers: W
-
-[cols="5*l"]
-|===
-| WAIT | WHEN | WHENEVER | WHERE | WHILE
-| WITH | WITHOUT | WORK | WRITE |
-|===
-
-
-[[reserved_sql_identifiers_y]]
-== Reserved SQL Identifiers Y
-
-[[reserved_sql_identifiers_z]]
-== Reserved SQL Identifiers: Z
-
-
+////
+/**
+* @@@ START COPYRIGHT @@@
+*
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements. See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership. The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License. You may obtain a copy of the License at
+*
+* http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing,
+* software distributed under the License is distributed on an
+* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+* KIND, either express or implied. See the License for the
+* specific language governing permissions and limitations
+* under the License.
+*
+* @@@ END COPYRIGHT @@@
+*/
+////
+
+[[reserved_words]]
+= Reserved Words
+The words listed in this appendix are reserved for use by {project-name} SQL.
+To prevent syntax errors, avoid using these words as identifiers in
+{project-name} SQL. In {project-name} SQL, if an operating system name contains a
+reserved word, you must enclose the reserved word in double quotes (")
+to access that column or object.
+
+NOTE: In {project-name} SQL, ABSOLUTE, DATA, EVERY, INITIALIZE, OPERATION,
+PATH, SPACE, STATE, STATEMENT, STATIC, and START are not reserved words.
+
+{project-name} SQL treats these words as reserved when they are part of
+{project-name} SQL stored text. They cannot be used as identifiers unless you
+enclose them in double quotes.
+
+[[reserved_sql_identifiers_a]]
+== Reserved SQL Identifiers: A
+
+
+[cols="5*l"]
+|===
+| ACTION | ADD | ADMIN | AFTER | AGGREGATE
+| ALIAS| | ALL | ALLOCATE | ALTER | AND
+| ANY | ARE | ARRAY | AS | ASC
+| ASSERTION| ASYNC | AT | AUTHORIZATION | AVG
+|===
+
+
+[[reserved_sql_identifiers_b]]
+== Reserved SQL Identifiers: B
+
+
+[cols="5*l"]
+|===
+| BEFORE | BEGIN | BETWEEN | BINARY | BIT
+| BIT_LENGTH | BLOB | BOOLEAN | BOTH | BREADTH
+| BY | | | |
+|===
+
+[[reserved_sql_identifiers_c]]
+== Reserved SQL Identifiers: C
+
+
+[cols="5*l"]
+|===
+| CALL | CASCADE | CASCADED | CASE | CAST
+| CATALOG | CHAR | CHARACTER | CHARACTER_LENGTH | CHAR_LENGTH
+| CHECK | CLASS | CLOB | CLOSE | COALESCE
+| COLLATE | COLLATION | COLUMN | COMMIT | COMPLETION
+| CONNECT | CONNECTION | CONSTRAINT | CONSTRAINTS | CONSTRUCTOR
+| CONTINUE | CONVERT | CORRESPONDING | COUNT | CREATE
+| CROSS | CUBE | CURRENT | CURRENT_DATE | CURRENT_PATH
+| CURRENT_ROLE | CURRENT_TIME | CURRENT_TIMESTAMP | CURRENT_USER | CURRNT_USR_INTN
+| CURSOR | CYCLE | | |
+|===
+
+
+[[reserved_sql_identifiers_d]]
+== Reserved SQL Identifiers: D
+
+[cols="5*l"]
+|===
+| DATE | DATETIME | DAY | DEALLOCATE | DEC
+| DECIMAL | DECLARE | DEFAULT | DEFERRABLE | DEFERRED
+| DELETE | DEPTH | DEREF | DESC | DESCRIBE
+| DESCRIPTOR | DESTROY | DESTRUCTOR | DETERMINISTIC | DIAGNOSTICS
+| DICTIONARY | DISCONNECT | DISTINCT | DOMAIN | DOUBLE
+| DROP | DYNAMIC | | |
+|===
+
+
+[[reserved_sql_identifiers_e]]
+== Reserved SQL Identifiers: E
+
+
+[cols="5*l"]
+|===
+| EACH | ELSE | ELSEIF | END | END-EXEC
+| EQUALS | ESCAPE | EXCEPT | EXCEPTION | EXEC
+| EXECUTE | EXISTS | EXTERNAL | EXTRACT |
+|===
+
+
+== Reserved SQL Identifers: F
+
+[cols="5*l"]
+|===
+| FALSE | FETCH | FIRST | FLOAT | FOR
+| FOREIGN | FOUND | FRACTION | FREE | FROM
+| FULL | FUNCTION | | |
+|===
+
+
+[[reserved_sql_identifiers_g]]
+== Reserved SQL Identifiers G
+
+[cols="5*l"]
+|===
+| GENERAL | GET | GLOBAL | GO | GOTO
+| GRANT | GROUP | GROUPING | |
+|===
+
+[[reserved_sql_identifiers_h]]
+== Reserved SQL Identifiers: H
+
+[[reserved_sql_identifiers_i]]
+== Reserved SQL Identifiers: I
+
+
+[cols="5*l"]
+|===
+| IDENTITY | IF | IGNORE | IMMEDIATE | IN
+| INDICATOR | INITIALLY | INNER | INOUT | INPUT
+| INSENSITIVE | INSERT | INT | INTEGER | INTERSECT
+| INTERVAL | INTO | IS | ISOLATION | ITERATE
+|===
+
+
+[[reserved_sql_identifiers_j]]
+== Reserved SQL Identifiers J
+
+[[reserved_sql_identifiers_k]]
+== Reserved SQL Identifiers: K
+
+[[reserved_sql_identifiers_l]]
+== Reserved SQL Identifiers: L
+
+[cols="5*l"]
+|===
+| LANGUAGE | LARGE | LAST | LATERAL | LEADING
+| LEAVE | LEFT | LESS | LEVEL | LIKE
+| LIMIT | LOCAL | LOCALTIME | LOCALTIMESTAMP | LOCATOR
+| LOOP | LOWER | | |
+|===
+
+
+[[reserved_sql_identifiers_m]]
+== Reserved SQL Identifiers: M
+
+[cols="5*l"]
+|===
+| MAINTAIN | MAP | MATCH | MATCHED | MAX
+| MERGE | MIN | MINUTE | MODIFIES | MODIFY
+| MODULE | MONTH | | |
+|===
+
+
+[[reserved_sql_identifiers_n]]
+== Reserved SQL Identifiers: N
+
+[cols="5*l"]
+|===
+| NAMES | NATIONAL | NATURAL | NCHAR | NCLOB
+| NEW | NEXT | NO | NONE | NOT
+| NULL | NULLIF | NUMERIC | |
+|===
+
+[[reserved_sql_identifiers_o]]
+== Reserved SQL Identifiers: O
+
+[cols="5*l"]
+|===
+| OCTET_LENGTH | OF | OFF | OID | OLD
+| ON | ONLY | OPEN | OPERATORS | OPTION
+| OPTIONS | OR | ORDER | ORDINALITY | OTHERS
+| OUT | OUTER | OUTPUT | OVERLAPS |
+|===
+
+
+[[reserved_sql_identifiers_p]]
+== Reserved SQL Identifiers: P
+
+[cols="5*l"]
+|===
+| PAD | PARAMETER | PARAMETERS | PARTIAL | PENDANT
+| POSITION | POSTFIX | PRECISION | PREFIX | PREORDER
+| PREPARE | PRESERVE | PRIMARY | PRIOR | PRIVATE
+| PRIVILEGES | PROCEDURE | PROTECTED | PROTOTYPE | PUBLIC
+|===
+
+
+[[reserved_sql_identifiers_q]]
+== Reserved SQL Identifiers: Q
+
+[[reserved_sql_identifiers_r]]
+== Reserved SQL Identifiers: R
+
+[cols="5*l"]
+|===
+| READ | READS | REAL | RECURSIVE | REF
+| REFERENCES | REFERENCING | RELATIVE | REORG | REORGANIZE
+| REPLACE | RESIGNAL | RESTRICT | RESULT | RETURN
+| RETURNS | REVOKE | RIGHT | ROLLBACK | ROLLUP
+| ROUTINE | ROW | ROWS | |
+|===
+
+[[reserved_sql_identifiers_s]]
+== Reserved SQL Identifiers: S
+
+[cols="5*l"]
+|===
+| SAVEPOINT | SCHEMA | SCOPE | SCROLL | SEARCH
+| SECOND | SECTION | SELECT | SENSITIVE | SESSION
+| SESSION_USER | SESSN_USR_INTN | SET | SETS | SIGNAL
+| SIMILAR | SIZE | SMALLINT | SOME | SPECIFIC
+| SPECIFICTYPE | SQL | SQL_CHAR | SQL_DATE | SQL_DECIMAL
+| SQL_DOUBLE | SQL_FLOAT | SQL_INT | SQL_INTEGER | SQL_REAL
+| SQL_SMALLINT | SQL_TIME | SQL_TIMESTAMP | SQL_VARCHAR | SQLCODE
+| SQLERROR | SQLEXCEPTION | SQLSTATE | SQLWARNING | STRUCTURE
+| SUBSTRING | SUM | SYNONYM | SYSTEM_USER |
+|===
+
+
+[[reserved_sql_identifiers_t]]
+== Reserved SQL Identifiers: T
+
+[cols="5*l"]
+|===
+| TABLE | TEMPORARY | TERMINATE | TEST | THAN
+| THEN | THERE | TIME | TIMESTAMP | TIMEZONE_HOUR
+| TIMEZONE_MINUTE | TO | TRAILING | TRANSACTION | TRANSLATE
+| TRANSLATION | TRANSPOSE | TREAT | TRIGGER | TRIM
+| TRUE | | | |
+|===
+
+[[reserved_sql_identifiers_u]]
+== Reserved SQL Identifiers: U
+
+[cols="5*l"]
+|===
+| UNDER | UNION | UNIQUE | UNKNOWN | UNNEST
+| UPDATE | UPPER | UPSHIFT | USAGE | USER
+| USING | | | |
+|===
+
+[[reserved_sql_identifiers_v]]
+== Reserved SQL Identifiers: V
+
+[cols="5*l"]
+|===
+| VALUE | VALUES | VARCHAR | VARIABLE | VARYING
+| VIEW | VIRTUAL | VISIBLE | |
+|===
+
+[[reserved_sql_identifiers_w]]
+== Reserved SQL Identifiers: W
+
+[cols="5*l"]
+|===
+| WAIT | WHEN | WHENEVER | WHERE | WHILE
+| WITH | WITHOUT | WORK | WRITE |
+|===
+
+
+[[reserved_sql_identifiers_y]]
+== Reserved SQL Identifiers Y
+
+[[reserved_sql_identifiers_z]]
+== Reserved SQL Identifiers: Z
+
+