Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SELECT statementUse the SELECT statement to retrieve values from a database or from an SPL or collection variable. A SELECT operation is called a query.
Projection ClauseThe Projection clause (sometimes called the Select clause) specifies a list of database objects or expressions to retrieve, and can set restrictions on qualifying rows. (The select list is sometimes also called the projection list.)
Expressions in the Select List
Selecting OLAP window expressionsYou can include OLAP window expressions in the select list of the Projection clause.

Selecting OLAP window expressions

You can include OLAP window expressions in the select list of the Projection clause.

The On-Line Analytical Processing (OLAP) functions can return ranking, row numbering, and aggregate function information for the entire result set of a query or subquery, or for partitioned subsets of the qualifying rows that the OLAP window defines. You can use OLAP specifications to define moving windows within a partition of the result set for examining dimensions of the data, and identifying patterns, trends, and exceptions within data sets.

A query that includes OLAP window expressions returns the rows in the result set of the query, and the results of the OLAP window functions, if those functions return anything.

An OLAP window aggregate function expression can be the argument to another OLAP window aggregate function. OLAP window aggregates cannot, however, be arguments to non-analytic aggregate functions.