1 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”