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 $352.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 2382:2015 Information technology – Vocabulary
CDN $0.00 Add to cart -
ISO 80004:2021 Nanotechnologies – Vocabulary – Part 6: Nano-object characterization
CDN $86.00 Add to cart -
ISO 20537:2025 Footwear – Identification of defects during visual inspection – Vocabulary
CDN $310.00 Add to cart -
ISO 16520:2025 Tourism and related services – Restaurants and catering – Vocabulary
CDN $195.00 Add to cart
