Codes & Standards - Purchase
ISO/IEC TR 19075-9:2020
Information technology database languages — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities
SKU: iso_076589_177451
Published by ISO/IEC
Publication Year 2020
1 Edition
48 pages
Product Details
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.
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.
