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.