{"id":431485,"date":"2024-10-20T07:28:31","date_gmt":"2024-10-20T07:28:31","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/bs-iso-iec-19075-92022-tc\/"},"modified":"2024-10-26T14:12:36","modified_gmt":"2024-10-26T14:12:36","slug":"bs-iso-iec-19075-92022-tc","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/bsi\/bs-iso-iec-19075-92022-tc\/","title":{"rendered":"BS ISO\/IEC 19075-9:2022 – TC"},"content":{"rendered":"

PDF Catalog<\/h4>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
PDF Pages<\/th>\nPDF Title<\/th>\n<\/tr>\n
72<\/td>\nundefined <\/td>\n<\/tr>\n
75<\/td>\nContents <\/td>\n<\/tr>\n
77<\/td>\nTables <\/td>\n<\/tr>\n
78<\/td>\nExamples <\/td>\n<\/tr>\n
79<\/td>\nForeword <\/td>\n<\/tr>\n
81<\/td>\nIntroduction <\/td>\n<\/tr>\n
83<\/td>\n1 Scope <\/td>\n<\/tr>\n
84<\/td>\n2 Normative references <\/td>\n<\/tr>\n
85<\/td>\n3 Terms and definitions <\/td>\n<\/tr>\n
86<\/td>\n4 Example data
4.1 Introduction to example data
4.2 Table sales history <\/td>\n<\/tr>\n
87<\/td>\n4.3 Table stock1 <\/td>\n<\/tr>\n
88<\/td>\n4.4 Table stocks
4.5 Table homes <\/td>\n<\/tr>\n
90<\/td>\n5 Windows
5.1 Introduction to windows
5.2 Window definitions
5.2.1 Introduction to window definitions <\/td>\n<\/tr>\n
91<\/td>\n5.2.2 Window partitioning <\/td>\n<\/tr>\n
92<\/td>\n5.2.3 Window ordering
5.2.3.1 Introduction to window ordering <\/td>\n<\/tr>\n
93<\/td>\n5.2.3.2 Null ordering and treatment <\/td>\n<\/tr>\n
94<\/td>\n5.2.4 Window frames
5.2.4.1 Introduction to window frames <\/td>\n<\/tr>\n
95<\/td>\n5.2.4.2 Physical window frames <\/td>\n<\/tr>\n
97<\/td>\n5.2.4.3 Logical window frames <\/td>\n<\/tr>\n
99<\/td>\n5.2.4.4 Window frame exclusions <\/td>\n<\/tr>\n
100<\/td>\n5.3 Explicit vs. implicit window definitions <\/td>\n<\/tr>\n
101<\/td>\n5.4 Multiple window definitions <\/td>\n<\/tr>\n
102<\/td>\n6 Window functions
6.1 Introduction to window functions
6.2 Rank functions <\/td>\n<\/tr>\n
103<\/td>\n6.3 Distribution functions <\/td>\n<\/tr>\n
104<\/td>\n6.4 Row number function <\/td>\n<\/tr>\n
105<\/td>\n6.5 Window aggregate functions <\/td>\n<\/tr>\n
108<\/td>\n6.6 Ntile function <\/td>\n<\/tr>\n
109<\/td>\n6.7 LEAD and LAG functions <\/td>\n<\/tr>\n
111<\/td>\n6.8 FIRST_VALUE and LAST_VALUE functions <\/td>\n<\/tr>\n
112<\/td>\n6.9 NTH_VALUE function <\/td>\n<\/tr>\n
114<\/td>\n6.10 Null treatment <\/td>\n<\/tr>\n
115<\/td>\n7 Nested window functions
7.1 Introduction to nested window functions <\/td>\n<\/tr>\n
116<\/td>\n7.2 Row markers <\/td>\n<\/tr>\n
117<\/td>\n7.3 Offsets <\/td>\n<\/tr>\n
118<\/td>\n7.4 FRAME_ROW <\/td>\n<\/tr>\n
119<\/td>\n7.5 Nested ROW_NUMBER function <\/td>\n<\/tr>\n
120<\/td>\n7.6 Effects of EXCLUDE <\/td>\n<\/tr>\n
122<\/td>\n8 Enhanced aggregate functions
8.1 Introduction to enhanced aggregate functions
8.2 Unary statistical aggregate functions <\/td>\n<\/tr>\n
123<\/td>\n8.3 Binary statistical aggregate functions <\/td>\n<\/tr>\n
126<\/td>\n8.4 Hypothetical rank and distribution aggregate functions <\/td>\n<\/tr>\n
127<\/td>\n8.5 Inverse distribution functions <\/td>\n<\/tr>\n
129<\/td>\nBibliography <\/td>\n<\/tr>\n
130<\/td>\nIndex <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Tracked Changes. Information technology. Guidance for the use of database language SQL – Online analytic processing (OLAP) capabilities (Guide\/OLAP)<\/b><\/p>\n\n\n\n\n
Published By<\/td>\nPublication Date<\/td>\nNumber of Pages<\/td>\n<\/tr>\n
BSI<\/b><\/a><\/td>\n2023<\/td>\n134<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":431494,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[2641],"product_tag":[],"class_list":{"0":"post-431485","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-bsi","8":"first","9":"instock","10":"sold-individually","11":"shipping-taxable","12":"purchasable","13":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product\/431485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media\/431494"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=431485"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=431485"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=431485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}