ISO/IEC 19075-9:2022
Information technology - Guidance for the use of database language SQL - Part 9: Online analytic processing (OLAP) capabilities (Guide/OLAP)
Abstract
ISO/IEC 19075-9:2022 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”
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”
Look inside
Additional information
| Publication type | International Standard |
|---|---|
| Publication date | 2022-10-03 |
| Edition | 1.0 |
| Available language(s) | English |
| TC/SC | ISO/IEC JTC 1/SC 32 - Data management and interchangerss |
| ICS | 35.060 - Languages used in information technology |
| Pages | 49 |
| File size | 1690 KB |
The following test report forms are related:
Share your publications
Learn how to share your publications with your colleagues, using networking options.
Payment information
Our prices are in Swiss francs (CHF). We accept all major credit cards (American Express, Mastercard and Visa, JCB and CUP), PayPal and bank transfers as form of payment.
Keep in touch
Keep up to date with new publication releases and announcements with our free IEC Just Published email newsletter.
Contact customer services
Please send your enquiry by email or call us on +41 22 919 02 11 between 09:00 – 16:00 CET Monday to Friday.