🔥🔥 Don’t Miss Out on Our End of Autumn Sale. If you have any questions, feel free to click the bottom right corner to contact our customer service..

Concat us[email protected]
Shopping Cart

No products in the cart.

🔍
BSI PD ISO/IEC TR 19075-9:2020

BSI PD ISO/IEC TR 19075-9:2020

$198.66

Information technology database languages. Guidance for the use of database language SQL – Online analytic processing (OLAP) capabilities

Published By Publication Date Number of Pages
BSI 2020 60
PDF Format Searchable Printable Preview Now
Guaranteed Safe Checkout
Category:

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]

PDF Catalog

PDF Pages PDF Title
2 undefined
5 Contents
7 Tables
8 Foreword
10 Introduction
11 1 Scope
12 2 Normative references
13 3 Terms and definitions
14 4 Example data
4.1 Introduction to example data
4.2 Table sales history
15 4.3 Table stock1
16 4.4 Table stocks
4.5 Table homes
18 5 Windows
5.1 Introduction to windows
19 5.2 Window definitions
5.2.1 Introduction to Window definitions
5.2.2 Window partitioning
20 5.2.3 Window ordering
5.2.3.1 Introduction to window ordering
22 5.2.3.2 Null ordering and treatment
5.2.4 Window frames
5.2.4.1 Introduction to window frames
23 5.2.4.2 Physical window frames
25 5.2.4.3 Logical window frames
27 5.2.4.4 Window frame exclusions
29 5.3 Explicit vs implicit window definitions
5.4 Multiple window definitions
31 6 Window functions
6.1 Introduction to window functions
6.2 Rank functions
32 6.3 Distribution functions
33 6.4 Row number function
34 6.5 Window aggregate functions
37 6.6 Ntile function
38 6.7 LEAD and LAG functions
40 6.8 FIRST_VALUE and LAST_VALUE functions
41 6.9 NTH_VALUE function
43 6.9.1 Null treatment
44 7 Nested window functions
7.1 Introduction to nested window functions
45 7.2 Row markers
46 7.3 Offsets
47 7.4 FRAME_ROW
48 7.5 Nested ROW_NUMBER function
50 7.6 Effects of EXCLUDE
51 8 Enhanced aggregate functions
8.1 Introduction to enhanced aggregate functions
8.2 Unary statistical aggregate functions
8.3 Binary statistical aggregate functions
53 8.4 Hypothetical rank and distribution aggregate functions
8.5 Inverse distribution functions

Related products

BSI PD ISO/IEC TR 19075-9:2020
$198.66