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

🔍
BS ISO/IEC 19075-9:2022 – TC:2023 Edition

BS ISO/IEC 19075-9:2022 – TC:2023 Edition

$258.95

Tracked Changes. Information technology. Guidance for the use of database language SQL – Online analytic processing (OLAP) capabilities (Guide/OLAP)

Published By Publication Date Number of Pages
BSI 2023 134
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
72 undefined
75 Contents
77 Tables
78 Examples
79 Foreword
81 Introduction
83 1 Scope
84 2 Normative references
85 3 Terms and definitions
86 4 Example data
4.1 Introduction to example data
4.2 Table sales history
87 4.3 Table stock1
88 4.4 Table stocks
4.5 Table homes
90 5 Windows
5.1 Introduction to windows
5.2 Window definitions
5.2.1 Introduction to window definitions
91 5.2.2 Window partitioning
92 5.2.3 Window ordering
5.2.3.1 Introduction to window ordering
93 5.2.3.2 Null ordering and treatment
94 5.2.4 Window frames
5.2.4.1 Introduction to window frames
95 5.2.4.2 Physical window frames
97 5.2.4.3 Logical window frames
99 5.2.4.4 Window frame exclusions
100 5.3 Explicit vs. implicit window definitions
101 5.4 Multiple window definitions
102 6 Window functions
6.1 Introduction to window functions
6.2 Rank functions
103 6.3 Distribution functions
104 6.4 Row number function
105 6.5 Window aggregate functions
108 6.6 Ntile function
109 6.7 LEAD and LAG functions
111 6.8 FIRST_VALUE and LAST_VALUE functions
112 6.9 NTH_VALUE function
114 6.10 Null treatment
115 7 Nested window functions
7.1 Introduction to nested window functions
116 7.2 Row markers
117 7.3 Offsets
118 7.4 FRAME_ROW
119 7.5 Nested ROW_NUMBER function
120 7.6 Effects of EXCLUDE
122 8 Enhanced aggregate functions
8.1 Introduction to enhanced aggregate functions
8.2 Unary statistical aggregate functions
123 8.3 Binary statistical aggregate functions
126 8.4 Hypothetical rank and distribution aggregate functions
127 8.5 Inverse distribution functions
129 Bibliography
130 Index

Related products

BS ISO/IEC 19075-9:2022 - TC
$258.95