Skip to main content

ISO/IEC TR 19075-9:2020

Withdrawn Date published:

Warning: Withdrawn Standard. This document has been withdrawn without replacement. You may wish to search for a more up to date equivalent.

Information technology database languages — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities

This document discusses the syntax and semantics for including online analytic processing (OLAP) capabilities in SQL, as defined in ISO/IEC 9075-2.

It discusses the following features regarding OLAP capabilities of the SQL language:

— Feature T611, "Elementary OLAP operations",

— Feature T612, "Advanced OLAP operations",

— Feature T614, "NTILE function",

— Feature T615, "LEAD and LAG functions",

— Feature T616, "Null treatment option for LEAD and LAG functions",

— Feature T617, "FIRST_VALUE and LAST_VALUE functions",

— Feature T618, "NTH_VALUE function",

— Feature T619, "Nested window functions",

— Feature T620, "WINDOW clause: GROUPS option",

— Feature T621, "Enhanced numeric functions".

Get this standard Prices exclude GST
PDF ( Single user document)
$91.24 NZD
HardCopy
$91.24 NZD
Networkable PDF
Price varies
Preview only close
Prev {{ page }}/ {{ numPages }} Next
Preview only close
Prev {{ page }}/ {{ numPages }} Next
Pages: 48

Keep me up-to-date

Sign up to receive updates when there are changes to this standard

Related Information

Similar Standards

  • AS/NZS 1486:1993

    Information technology - Programming languages - Fortran 90

  • AS/NZS 3968.0:1994

    Information technology - Database languages - SQL - Definition of data structures and basic operations

  • AS/NZS 3968.0:1994 A1

    Information technology - Database languages - SQL - Definition of data structures and basic operations: Amendment 1

  • AS/NZS 3968.3:1998

    Information technology - Database languages - SQL - Call-level interface

Preview only close
Prev {{ page }}/ {{ numPages }} Next
Preview only close
Prev {{ page }}/ {{ numPages }} Next
Pages: 48

ISO/IEC TR 19075-9:2020

Get this standard Prices exclude GST
PDF ( Single user document)
$91.24 NZD
HardCopy
$91.24 NZD
Networkable PDF
Price varies

Request to add this standard to your subscription

ISO/IEC TR 19075-9:2020

Price varies
Online library subscription

Click "Send request for subscription" to request for your Account Administrator to add this standard to your subscripiton.

Cancel