ISO 19075:2022
ISO 19075:2022 Information technology – Guidance for the use of database language SQL – Part 9: Online analytic processing (OLAP) capabilities (Guide/OLAP)
CDN $312.00
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”
Edition
1
Published Date
2022-10-03
Status
PUBLISHED
Pages
49
Language
English
Format
Secure PDF
Secure – PDF details
- Save your file locally or view it via a web viewer
- Viewing permissions are restricted exclusively to the purchaser
- Device limits - 3
- Printing – Enabled only to print (1) copy
See more about our Environmental Commitment
Abstract
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”
Previous Editions
Can’t find what you are looking for?
Please contact us at:
Related Documents
-
ISO 22553:2019 Paints and varnishes – Electro-deposition coatings – Part 1: Vocabulary
CDN $76.00 Add to cart -
ISO 4006:1991 Measurement of fluid flow in closed conduits – Vocabulary and symbols
CDN $351.00 Add to cart -
ISO 80004:2011 Nanotechnologies – Vocabulary – Part 5: Nano/bio interface
CDN $76.00 Add to cart -
ISO 15424:2025 Information technology – Automatic identification and data capture techniques – Data carrier identifiers (including symbology identifiers)
CDN $233.00 Add to cart
