Logo
Login Sign Up
Current Revision

ISO/IEC 19075-9:2022

Information technology - Guidance for the use of database language SQL - Part 9: Online analytic processing (OLAP) capabilities (Guide/OLAP)
Best Price Guarantee
Instant

$228.69

2-5 Days

$228.69

SAVE 15%

$388.77


Sub Total (1 Item(s))

$ 0.00

Estimated Shipping

$ 0.00

Total (Pre-Tax)

$ 0.00


View in Library
or
International Organization for Standardization Logo

ISO/IEC 19075-9:2022

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

PUBLISH DATE 2022
ISO/IEC 19075-9:2022

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, "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"
SDO ISO: International Organization for Standardization
Document Number ISO/IEC 19075
Publication Date Oct. 1, 2022
Language en - English
Page Count
Revision Level
Supercedes
Committee ISO/IEC JTC 1/SC 32
Loading...

Failed to load document history.

Publish Date Document Id Type View