PRICES include / exclude VAT
Homepage>ISO Standards>ISO/IEC TR 19075-9 Information technology database languages — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities
Sponsored link
download between 0-24 hoursReleased: 2020
ISO/IEC TR 19075-9 Information technology database languages — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities

ISO/IEC TR 19075-9

Information technology database languages — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities

CURRENCY
LANGUAGE
English
Standard´s number:ISO/IEC TR 19075-9
Pages:48
Edition:1
Released:2020
Language:English
DESCRIPTION

ISO/IEC TR 19075-9


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.
This product includes: