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".