Phone: (011) 7541-421, 3409-301, 3409-335, 6547-293, 3409-310
E-mail: Standards sales: prodaja@iss.rs Education: iss-edukacija@iss.rs Information about standards: infocentar@iss.rs
Stevana Brakusa 2, 11030 Beograd
Main menu

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

Sep 18, 2020
95.99   Withdrawal of Standard   Oct 3, 2022

General information

95.99     Oct 3, 2022

ISO/IEC

ISO/IEC JTC 1/SC 32

Technical Report

35.060  

English  

Buying

Withdrawn

Language in which you want to receive the document.

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