Compare


Product Product ISO/IEC 19075-9:2022
Price Price USD 192.00
Rating Rating
Buy Buy Add to Cart
Description Description

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”

Standard Number Standard Number ISO/IEC 19075-9:2022
Title Title ISO/IEC 19075-9:2022 Information technology — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities (Guide/OLAP)
Status Status Published
Publication Date Publication Date 03 Oct 2022
Cross References Cross References
Descriptors Descriptors
ICS ICS 35.060
Committee Committee ISO/IEC JTC 1/SC 32 Data management and interchange
ISBN ISBN
Publisher Publisher PECB Store
Format Format PDF
Delivery Delivery NO
Pages Pages 49
File Size File Size KB