{"id":353939,"date":"2024-10-20T01:00:34","date_gmt":"2024-10-20T01:00:34","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/bsi-pd-iso-iec-tr-19075-92020\/"},"modified":"2024-10-26T01:11:43","modified_gmt":"2024-10-26T01:11:43","slug":"bsi-pd-iso-iec-tr-19075-92020","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/bsi\/bsi-pd-iso-iec-tr-19075-92020\/","title":{"rendered":"BSI PD ISO\/IEC TR 19075-9:2020"},"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
PDF Pages<\/th>\nPDF Title<\/th>\n<\/tr>\n
2<\/td>\nundefined <\/td>\n<\/tr>\n
5<\/td>\nContents <\/td>\n<\/tr>\n
7<\/td>\nTables <\/td>\n<\/tr>\n
8<\/td>\nForeword <\/td>\n<\/tr>\n
10<\/td>\nIntroduction <\/td>\n<\/tr>\n
11<\/td>\n1 Scope <\/td>\n<\/tr>\n
12<\/td>\n2 Normative references <\/td>\n<\/tr>\n
13<\/td>\n3 Terms and definitions <\/td>\n<\/tr>\n
14<\/td>\n4 Example data
4.1 Introduction to example data
4.2 Table sales history <\/td>\n<\/tr>\n
15<\/td>\n4.3 Table stock1 <\/td>\n<\/tr>\n
16<\/td>\n4.4 Table stocks
4.5 Table homes <\/td>\n<\/tr>\n
18<\/td>\n5 Windows
5.1 Introduction to windows <\/td>\n<\/tr>\n
19<\/td>\n5.2 Window definitions
5.2.1 Introduction to Window definitions
5.2.2 Window partitioning <\/td>\n<\/tr>\n
20<\/td>\n5.2.3 Window ordering
5.2.3.1 Introduction to window ordering <\/td>\n<\/tr>\n
22<\/td>\n5.2.3.2 Null ordering and treatment
5.2.4 Window frames
5.2.4.1 Introduction to window frames <\/td>\n<\/tr>\n
23<\/td>\n5.2.4.2 Physical window frames <\/td>\n<\/tr>\n
25<\/td>\n5.2.4.3 Logical window frames <\/td>\n<\/tr>\n
27<\/td>\n5.2.4.4 Window frame exclusions <\/td>\n<\/tr>\n
29<\/td>\n5.3 Explicit vs implicit window definitions
5.4 Multiple window definitions <\/td>\n<\/tr>\n
31<\/td>\n6 Window functions
6.1 Introduction to window functions
6.2 Rank functions <\/td>\n<\/tr>\n
32<\/td>\n6.3 Distribution functions <\/td>\n<\/tr>\n
33<\/td>\n6.4 Row number function <\/td>\n<\/tr>\n
34<\/td>\n6.5 Window aggregate functions <\/td>\n<\/tr>\n
37<\/td>\n6.6 Ntile function <\/td>\n<\/tr>\n
38<\/td>\n6.7 LEAD and LAG functions <\/td>\n<\/tr>\n
40<\/td>\n6.8 FIRST_VALUE and LAST_VALUE functions <\/td>\n<\/tr>\n
41<\/td>\n6.9 NTH_VALUE function <\/td>\n<\/tr>\n
43<\/td>\n6.9.1 Null treatment <\/td>\n<\/tr>\n
44<\/td>\n7 Nested window functions
7.1 Introduction to nested window functions <\/td>\n<\/tr>\n
45<\/td>\n7.2 Row markers <\/td>\n<\/tr>\n
46<\/td>\n7.3 Offsets <\/td>\n<\/tr>\n
47<\/td>\n7.4 FRAME_ROW <\/td>\n<\/tr>\n
48<\/td>\n7.5 Nested ROW_NUMBER function <\/td>\n<\/tr>\n
50<\/td>\n7.6 Effects of EXCLUDE <\/td>\n<\/tr>\n
51<\/td>\n8 Enhanced aggregate functions
8.1 Introduction to enhanced aggregate functions
8.2 Unary statistical aggregate functions
8.3 Binary statistical aggregate functions <\/td>\n<\/tr>\n
53<\/td>\n8.4 Hypothetical rank and distribution aggregate functions
8.5 Inverse distribution functions <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Information technology database languages. Guidance for the use of database language SQL – Online analytic processing (OLAP) capabilities<\/b><\/p>\n\n\n\n\n
Published By<\/td>\nPublication Date<\/td>\nNumber of Pages<\/td>\n<\/tr>\n
BSI<\/b><\/a><\/td>\n2020<\/td>\n60<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":353946,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[2641],"product_tag":[],"class_list":{"0":"post-353939","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\/353939","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\/353946"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=353939"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=353939"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=353939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}