{"id":562,"date":"2020-09-25T14:12:56","date_gmt":"2020-09-25T14:12:56","guid":{"rendered":"https:\/\/lucient.com\/en\/?post_type=books_publications&#038;p=562"},"modified":"2021-02-19T11:14:17","modified_gmt":"2021-02-19T11:14:17","slug":"t-sql-window-functions-second-edition","status":"publish","type":"books_publications","link":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/","title":{"rendered":"T-SQL Window Functions Second Edition"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">This book is intended for SQL Server developers, database administrators (DBAs), data scientists, business intelligence (BI) specialists, and those who need to write queries and develop code using T-SQL. The book assumes that you already have at least six months to a year of experience writing and tuning T-SQL queries.<br>The book covers both the logical aspects of window functions as well as their optimization and practical usage aspects.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-white-color has-text-color has-background\" href=\"https:\/\/www.amazon.com\/T-SQL-Window-Functions-Developer-Reference\/dp\/0135861446\/ref=sr_1_1?dchild=1&amp;keywords=0135861446&amp;qid=1592937285&amp;sr=8-1\" style=\"border-radius:5px;background-color:#a17df6\" target=\"_blank\" rel=\"noreferrer noopener\">Buy on Amazon<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This book covers both the SQL Server\u2013specific support for window functions as well as the SQL standard\u2019s support.<\/p>\n","protected":false},"featured_media":1161,"menu_order":0,"template":"","class_list":["post-562","books_publications","type-books_publications","status-publish","has-post-thumbnail","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>T-SQL Window Functions Second Edition - Lucient - North America<\/title>\n<meta name=\"description\" content=\"For over 30 years, we have authored 30 books about T-SQL, Azure, Power BI and Microsoft&#039;s exams. Find them here and buy them online.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T-SQL Window Functions Second Edition - Lucient - North America\" \/>\n<meta property=\"og:description\" content=\"For over 30 years, we have authored 30 books about T-SQL, Azure, Power BI and Microsoft&#039;s exams. Find them here and buy them online.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/\" \/>\n<meta property=\"og:site_name\" content=\"Lucient - North America\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/LucientData\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-19T11:14:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lucient.com\/en\/wp-content\/uploads\/sites\/7\/2020\/09\/T-SQL-Window-Functions-Second-Edition.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"450\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@lucient_data\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/books_publications\\\/t-sql-window-functions-second-edition\\\/\",\"url\":\"https:\\\/\\\/lucient.com\\\/en\\\/books_publications\\\/t-sql-window-functions-second-edition\\\/\",\"name\":\"T-SQL Window Functions Second Edition - Lucient - North America\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/books_publications\\\/t-sql-window-functions-second-edition\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/books_publications\\\/t-sql-window-functions-second-edition\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/lucient.com\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/7\\\/2020\\\/09\\\/T-SQL-Window-Functions-Second-Edition.jpg\",\"datePublished\":\"2020-09-25T14:12:56+00:00\",\"dateModified\":\"2021-02-19T11:14:17+00:00\",\"description\":\"For over 30 years, we have authored 30 books about T-SQL, Azure, Power BI and Microsoft's exams. Find them here and buy them online.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/books_publications\\\/t-sql-window-functions-second-edition\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/lucient.com\\\/en\\\/books_publications\\\/t-sql-window-functions-second-edition\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/books_publications\\\/t-sql-window-functions-second-edition\\\/#primaryimage\",\"url\":\"https:\\\/\\\/lucient.com\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/7\\\/2020\\\/09\\\/T-SQL-Window-Functions-Second-Edition.jpg\",\"contentUrl\":\"https:\\\/\\\/lucient.com\\\/en\\\/wp-content\\\/uploads\\\/sites\\\/7\\\/2020\\\/09\\\/T-SQL-Window-Functions-Second-Edition.jpg\",\"width\":450,\"height\":450},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/books_publications\\\/t-sql-window-functions-second-edition\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/lucient.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Books &amp; Publications\",\"item\":\"https:\\\/\\\/lucient.com\\\/en\\\/books_publications\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"T-SQL Window Functions Second Edition\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/lucient.com\\\/en\\\/\",\"name\":\"Lucient - North America\",\"description\":\"Empowering businesses with data analytics\",\"publisher\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/lucient.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/#organization\",\"name\":\"Lucient\",\"url\":\"https:\\\/\\\/lucient.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/lucient.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/Lucient-Logo-Pos-RGB.png\",\"contentUrl\":\"https:\\\/\\\/lucient.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/Lucient-Logo-Pos-RGB.png\",\"width\":2540,\"height\":568,\"caption\":\"Lucient\"},\"image\":{\"@id\":\"https:\\\/\\\/lucient.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/LucientData\",\"https:\\\/\\\/x.com\\\/lucient_data\",\"https:\\\/\\\/instagra.com\\\/lucient_data\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/lucientdata\",\"https:\\\/\\\/youtube.com\\\/channel\\\/UCLr1d81OFqPo13IQ9-htVWQ\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T-SQL Window Functions Second Edition - Lucient - North America","description":"For over 30 years, we have authored 30 books about T-SQL, Azure, Power BI and Microsoft's exams. Find them here and buy them online.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/","og_locale":"en_US","og_type":"article","og_title":"T-SQL Window Functions Second Edition - Lucient - North America","og_description":"For over 30 years, we have authored 30 books about T-SQL, Azure, Power BI and Microsoft's exams. Find them here and buy them online.","og_url":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/","og_site_name":"Lucient - North America","article_publisher":"https:\/\/www.facebook.com\/LucientData","article_modified_time":"2021-02-19T11:14:17+00:00","og_image":[{"width":450,"height":450,"url":"https:\/\/lucient.com\/en\/wp-content\/uploads\/sites\/7\/2020\/09\/T-SQL-Window-Functions-Second-Edition.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@lucient_data","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/","url":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/","name":"T-SQL Window Functions Second Edition - Lucient - North America","isPartOf":{"@id":"https:\/\/lucient.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/#primaryimage"},"image":{"@id":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/#primaryimage"},"thumbnailUrl":"https:\/\/lucient.com\/en\/wp-content\/uploads\/sites\/7\/2020\/09\/T-SQL-Window-Functions-Second-Edition.jpg","datePublished":"2020-09-25T14:12:56+00:00","dateModified":"2021-02-19T11:14:17+00:00","description":"For over 30 years, we have authored 30 books about T-SQL, Azure, Power BI and Microsoft's exams. Find them here and buy them online.","breadcrumb":{"@id":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/#primaryimage","url":"https:\/\/lucient.com\/en\/wp-content\/uploads\/sites\/7\/2020\/09\/T-SQL-Window-Functions-Second-Edition.jpg","contentUrl":"https:\/\/lucient.com\/en\/wp-content\/uploads\/sites\/7\/2020\/09\/T-SQL-Window-Functions-Second-Edition.jpg","width":450,"height":450},{"@type":"BreadcrumbList","@id":"https:\/\/lucient.com\/en\/books_publications\/t-sql-window-functions-second-edition\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/lucient.com\/en\/"},{"@type":"ListItem","position":2,"name":"Books &amp; Publications","item":"https:\/\/lucient.com\/en\/books_publications\/"},{"@type":"ListItem","position":3,"name":"T-SQL Window Functions Second Edition"}]},{"@type":"WebSite","@id":"https:\/\/lucient.com\/en\/#website","url":"https:\/\/lucient.com\/en\/","name":"Lucient - North America","description":"Empowering businesses with data analytics","publisher":{"@id":"https:\/\/lucient.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/lucient.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/lucient.com\/en\/#organization","name":"Lucient","url":"https:\/\/lucient.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/lucient.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/lucient.com\/wp-content\/uploads\/2021\/02\/Lucient-Logo-Pos-RGB.png","contentUrl":"https:\/\/lucient.com\/wp-content\/uploads\/2021\/02\/Lucient-Logo-Pos-RGB.png","width":2540,"height":568,"caption":"Lucient"},"image":{"@id":"https:\/\/lucient.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/LucientData","https:\/\/x.com\/lucient_data","https:\/\/instagra.com\/lucient_data","https:\/\/www.linkedin.com\/company\/lucientdata","https:\/\/youtube.com\/channel\/UCLr1d81OFqPo13IQ9-htVWQ"]}]}},"_links":{"self":[{"href":"https:\/\/lucient.com\/en\/wp-json\/wp\/v2\/books_publications\/562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lucient.com\/en\/wp-json\/wp\/v2\/books_publications"}],"about":[{"href":"https:\/\/lucient.com\/en\/wp-json\/wp\/v2\/types\/books_publications"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lucient.com\/en\/wp-json\/wp\/v2\/media\/1161"}],"wp:attachment":[{"href":"https:\/\/lucient.com\/en\/wp-json\/wp\/v2\/media?parent=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}