ISO/IEC TR 19075-9:2020
$46.15
Information technology database languages — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities
Published By | Publication Date | Number of Pages |
ISO | 2020-09 | 58 |
If you have any questions, feel free to reach out to our online customer service team by clicking on the bottom right corner. We’re here to assist you 24/7.
Email:[email protected]
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".
Published Code | ISO |
---|---|
Published By | International Organization for Standardization |
Publication Date | 2020-09 |
Pages Count | 58 |
Language | English |
Edition | 1 |
File Size | 1.4 MB |
ICS Codes | 35.060 - Languages used in information technology |
Related products
-
BSI PD ISO/IEC TR 19075-9:2020
Information technology database languages. Guidance for the use of database language SQL – Online analytic…
-
BS ISO/IEC 19075-5:2021
Information technology. Guidance for the use of database language SQL – Row pattern recognition Published…
-
IEEE P1003.1:2024 Edition
IEEE Draft Standard for Information Technology–Portable Operating System Interface (POSIX(TM)) Base Specifications, Issue 8 Published…
-
BS ISO/IEC 19075-3:2021
Information technology. Guidance for the use of database language SQL – SQL embedded in programs…
-
BSI PD ISO/IEC TR 19075-8:2019
Information technology database languages. SQL technical reports – Multi-dimensional arrays (SQL/MDA) Published By Publication Date…
-
IEEE ISO IEC 9945 2009
Information technology Portable Operating System Interface (POSIX) Base Specifications, Issue 7 Published By Publication Date…
-
BS ISO/IEC 19075-2:2021
Information technology. Guidance for the use of database language SQL – Time-related information Published By…
-
BS ISO/IEC 19075-4:2021
Information technology. Guidance for the use of database language SQL – Routines and types using…
-
BSI PD ISO/IEC TR 19075-1:2011
Information technology. Database languages. SQL technical reports – XQuery regular expression support in SQL Published…
-
BS ISO/IEC 19075-7:2021
Information technology. Guidance for the use of database language SQL – Polymorphic table functions Published…
-
IEEE 9945-2009
IEEE/ISO/IEC International Standard – Information technology Portable Operating System Interface (POSIX(TM)) Base Specifications, Issue 7…
-
IEEE 1003.1-2008
IEEE Standard for Information Technology – Portable Operating System Interface (POSIX(TM)) Published By Publication Date…
-
BSI PD CEN/TR 17868:2022
Intelligent transport systems. EU-ICIP. ITS standards deliverables (2022) Published By Publication Date Number of Pages…
-
BSI PD ISO/IEC TR 19075-6:2017
Information technology. Database languages. SQL Technical Reports – SQL support for JavaScript Object Notation (JSON)…
-
BS ISO/IEC 19075-5:2021
Information technology. Guidance for the use of database language SQL – Row pattern recognition Published…
-
BS ISO/IEC 19075-2:2021
Information technology. Guidance for the use of database language SQL – Time-related information Published By…
-
BS ISO/IEC 19075-4:2021
Information technology. Guidance for the use of database language SQL – Routines and types using…
-
IEEE 1003.1-2017
IEEE Standard for Information Technology–Portable Operating System Interface (POSIX(TM)) Base Specifications, Issue 7 (Superseded Redline)…
-
BSI PD ISO/IEC TR 19075-5:2016:2017 Edition
Information technology. Database languages. SQL Technical Reports – Row Pattern Recognition in SQL Published By…
-
BS ISO/IEC 19075-8:2021
Information technology. Guidance for the use of database language SQL – Multidimensional arrays Published By…
-
BSI PD ISO/IEC TR 19075-4:2015
Information technology. Database languages. SQL Technical Reports – SQL with Routines and types using the…
-
BS ISO/IEC 19075-3:2021
Information technology. Guidance for the use of database language SQL – SQL embedded in programs…
-
BS ISO/IEC 19075-6:2021
Information technology. Guidance for the use of database language SQL – Support for JSON Published…
-
IEEE 1003.1-2017
IEEE Standard for Information Technology–Portable Operating System Interface (POSIX(TM)) Base Specifications, Issue 7 Published By…
-
IEEE 1003.1 2008
Standard for Information Technology – Portable Operating System Interface (POSIX(R)) Published By Publication Date Number…
-
IEEE 1003.1-2017(Redline)
IEEE Standard for Information Technology–Portable Operating System Interface (POSIX(TM)) Base Specifications, Issue 7 (Redline) Published…
-
BS ISO/IEC 19075-6:2021
Information technology. Guidance for the use of database language SQL – Support for JSON Published…
-
BSI PD ISO/IEC TR 19075-3:2015
Information technology. Database languages. SQL Technical Reports – SQL Embedded in Programs using the JavaTM…
-
IEEE/ISO/IEC 9945 2009
IEEE/ISO/IEC International Standard – Information technology Portable Operating System Interface (POSIX(TM)) Base Specifications, Issue 7…
-
IEEE 1003.1-2024
IEEE/Open Group Standard for Information Technology–Portable Operating System Interface (POSIX™) Base Specifications, Issue 8 (Published)…
-
CSA ISO/IEC TR 19075-8:20:2020 Edition
Information technology database languages — SQL technical reports — Part 8: Multi-dimensional arrays (SQL/MDA) Published…
-
BSI PD ISO/TR 32220:2021
Sustainable finance. Basic concepts and key initiatives Published By Publication Date Number of Pages BSI…
-
BSI PD ISO/IEC TR 19075-2:2015
Information technology. Database languages. SQL Technical Reports – SQL Support for Time-Related Information Published By…
-
BSI PD ISO/TR 7655:2022
Corrosion of metals and alloys. Overview of metal corrosion protection when using disinfectants Published By…
-
BS ISO/IEC 19075-8:2021
Information technology. Guidance for the use of database language SQL – Multidimensional arrays Published By…
-
BS ISO/IEC 19075-1:2021
Information technology. Guidance for the use of database language SQL – XQuery regular expressions Published…
-
IEEE 1003.1-2024
IEEE/Open Group Standard for Information Technology–Portable Operating System Interface (POSIX™) Base Specifications, Issue 8 (Published)…
-
BS ISO/IEC 19075-7:2021
Information technology. Guidance for the use of database language SQL – Polymorphic table functions Published…
-
IEEE 1003.1-2024
IEEE/Open Group Standard for Information Technology–Portable Operating System Interface (POSIX™) Base Specifications, Issue 8 (Published)…
-
CSA ISO/IEC TR 19075-9:21:2021 Edition
Information technology database languages — Guidance for the use of database language SQL — Part…