{"id":14269,"date":"2020-05-01T23:14:01","date_gmt":"2020-05-01T23:14:01","guid":{"rendered":"https:\/\/www.gencayyildiz.com\/blog\/?p=14269"},"modified":"2020-05-01T23:14:01","modified_gmt":"2020-05-01T23:14:01","slug":"sql-server-grouping-sets","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/sql-server-grouping-sets\/","title":{"rendered":"SQL Server &#8211; GROUPING SETS"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>Merhaba,<\/p>\n<p>SQL raporlamada zaman zaman farkl\u0131 d\u00fczeylerde verileri bar\u0131nd\u0131ran birden fazla sorguyu farkl\u0131 kombinasyonlarda gruplama ihtiyac\u0131 duyabiliriz. Bunun i\u00e7in her bir grubu farkl\u0131 select sorgusuyla elde edip Union ya da Union All komutuyla a\u015fa\u011f\u0131daki gibi alt alta birle\u015ftirerek ama\u00e7lad\u0131\u011f\u0131m\u0131z b\u00fct\u00fcnsel veriyi elde edebiliriz.<\/p>\n<p><a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/03\/SQL-Server-GROUPING-SETS.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/03\/SQL-Server-GROUPING-SETS.jpg\" alt=\"SQL Server - GROUPING SETS\" width=\"448\" height=\"553\" class=\"alignnone size-full wp-image-14272\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/03\/SQL-Server-GROUPING-SETS.jpg 448w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/03\/SQL-Server-GROUPING-SETS-243x300.jpg 243w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/a><\/p>\n<p>Yukar\u0131daki gibi birden fazla sorgu \u00fczerinden farkl\u0131 kombinasyonlarda de\u011ferler \u00fcreterek b\u00fct\u00fcnsel bir veri elde etmek istiyorsak e\u011fer bunu union ya da union all ile birle\u015ftirmek yerine daha az maliyetli ve y\u00fcksek performansl\u0131 bir \u015fekilde yapmam\u0131z\u0131 sa\u011flayan Grouping Sets deyimini kullanarakta ger\u00e7ekle\u015ftirebiliriz.<\/p>\n<p>Grouping Sets deyimi, birden fazla grouplama i\u015flemi neticesinde olu\u015fturulmu\u015f sorgu par\u00e7ac\u0131klar\u0131ndan bir araya gelerek \u00fcretilen verileri tek seferde tan\u0131mlay\u0131p pratik bir \u015fekilde olu\u015fturmam\u0131z\u0131 sa\u011flayan bir yap\u0131lanmad\u0131r.<\/p>\n<p>Kullan\u0131m\u0131 a\u015fa\u011f\u0131daki gibidir;<br \/>\n<a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/03\/SQL-Server-GROUPING-SETS-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/03\/SQL-Server-GROUPING-SETS-1.jpg\" alt=\"SQL Server - GROUPING SETS\" width=\"443\" height=\"537\" class=\"alignnone size-full wp-image-14277\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/03\/SQL-Server-GROUPING-SETS-1.jpg 443w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2020\/03\/SQL-Server-GROUPING-SETS-1-247x300.jpg 247w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/a><\/p>\n<p>\u0130lgilenenlerin faydalanmas\u0131 dile\u011fiyle&#8230;<br \/>\nSonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere&#8230;<br \/>\n\u0130yi \u00e7al\u0131\u015fmalar&#8230;<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Merhaba, SQL raporlamada zaman zaman farkl\u0131 d\u00fczeylerde verileri bar\u0131nd\u0131ran birden fazla sorguyu farkl\u0131 kombinasyonlarda gruplama ihtiyac\u0131 duyabiliriz. Bunun i\u00e7in her bir grubu farkl\u0131 select sorgusuyla elde edip Union ya da Union All komutuyla a\u015fa\u011f\u0131daki&#46;&#46;&#46;<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":3415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1082,1412,22],"tags":[3275,245],"class_list":["post-14269","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","category-sql-server-2016","category-veritabani","tag-grouping-sets","tag-sql-server"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/14269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=14269"}],"version-history":[{"count":8,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/14269\/revisions"}],"predecessor-version":[{"id":14279,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/14269\/revisions\/14279"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/3415"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=14269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=14269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=14269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}