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".
Status: WithdrawnPublication date: 2020-09
Edition: 1Number of pages: 48
Technical Committee: ISO/IEC JTC 1/SC 32 Data management and interchange
- ICS :
- 35.060 Languages used in information technology
This standard contributes to the following Sustainable Development Goal:
ISO/IEC TR 19075-9:2020Stage: 95.99
Got a question?
Check out our FAQs
Monday to Friday - 09:00-12:00, 14:00-17:00 (UTC+1)
Keep up to date with ISO
Sign up to our newsletter for the latest news, views and product information.