Menu

0

ISO/IEC TR 19075-9:2020

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

Publication date:   Sep 18, 2020

95.99   Withdrawal of Standard   Oct 3, 2022

General information

95.99   Withdrawal of Standard   Oct 3, 2022

ISO/IEC

ISO/IEC JTC 1/SC 32 Data management and interchange

Technical Report

35.060   Languages used in information technology

Buying

  Withdrawn

PDF - €81.07

  English  



Buy

Scope

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".

Life cycle

NOW

WITHDRAWN
ISO/IEC TR 19075-9:2020
95.99 Withdrawal of Standard
Oct 3, 2022

REVISED BY

PUBLISHED
ISO/IEC 19075-9:2022