{"id":637468,"date":"2024-11-06T01:02:09","date_gmt":"2024-11-06T01:02:09","guid":{"rendered":"https:\/\/pdfstandards.shop\/product\/uncategorized\/iso-iec-tr-19075-92020\/"},"modified":"2024-11-06T01:02:09","modified_gmt":"2024-11-06T01:02:09","slug":"iso-iec-tr-19075-92020","status":"publish","type":"product","link":"https:\/\/pdfstandards.shop\/product\/publishers\/iso\/iso-iec-tr-19075-92020\/","title":{"rendered":"ISO\/IEC TR 19075-9:2020"},"content":{"rendered":"<p>This document discusses the syntax and semantics for including online analytic processing (OLAP) capabilities in SQL, as defined in ISO\/IEC 9075-2.<\/p>\n<p>It discusses the following features regarding OLAP capabilities of the SQL language:<\/p>\n<p>\u2014 Feature T611, &#034;Elementary OLAP operations&#034;,<\/p>\n<p>\u2014 Feature T612, &#034;Advanced OLAP operations&#034;,<\/p>\n<p>\u2014 Feature T614, &#034;NTILE function&#034;,<\/p>\n<p>\u2014 Feature T615, &#034;LEAD and LAG functions&#034;,<\/p>\n<p>\u2014 Feature T616, &#034;Null treatment option for LEAD and LAG functions&#034;,<\/p>\n<p>\u2014 Feature T617, &#034;FIRST_VALUE and LAST_VALUE functions&#034;,<\/p>\n<p>\u2014 Feature T618, &#034;NTH_VALUE function&#034;,<\/p>\n<p>\u2014 Feature T619, &#034;Nested window functions&#034;,<\/p>\n<p>\u2014 Feature T620, &#034;WINDOW clause: GROUPS option&#034;,<\/p>\n<p>\u2014 Feature T621, &#034;Enhanced numeric functions&#034;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><b>Information technology database languages \u2014 Guidance for the use of database language SQL \u2014 Part 9: Online analytic processing (OLAP) capabilities<\/b><\/p>\n<table style=\"width: 100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td>Published By<\/td>\n<td>Publication Date<\/td>\n<td>Number of Pages<\/td>\n<\/tr>\n<tr>\n<td><a href=\"https:\/\/pdfstandards.shop\/product-category\/publishers\/iso\/\"><b>ISO<\/b><\/a><\/td>\n<td>2020-09<\/td>\n<td>58<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":637482,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[664,2634],"product_tag":[],"class_list":{"0":"post-637468","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-35-060","7":"product_cat-iso","9":"first","10":"instock","11":"sold-individually","12":"shipping-taxable","13":"purchasable","14":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product\/637468","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\/637482"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=637468"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=637468"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=637468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}