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 $336.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 80004:2020 Nanotechnologies – Vocabulary – Part 8: Nanomanufacturing processes
CDN $82.00 Add to cart -
ISO 80004:2020 Nanotechnologies – Vocabulary – Part 3: Carbon nano-objects
CDN $82.00 Add to cart -
ISO 2574:1994 Aircraft – Electrical cables – Identification marking
CDN $124.00 Add to cart -
ISO 8384:2019 Ships and marine technology – Dredgers – Vocabulary
CDN $82.00 Add to cart
