ISO/IEC 19075-9
Information technology — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities (Guide/OLAP)
active, Most Current
| Organization: | ISO |
| Publication Date: | 1 October 2022 |
| Status: | active |
| Page Count: | 60 |
| ICS Code (Languages used in information technology): | 35.060 |
scope:
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"
Document History
ISO/IEC 19075-9
October 1, 2022
Information technology — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities (Guide/OLAP)
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...