{"id":321,"date":"2013-01-10T15:25:00","date_gmt":"1970-01-01T00:00:00","guid":{"rendered":"http:\/\/www.yazilimmutfagi.com\/?p=321"},"modified":"2018-11-12T00:45:01","modified_gmt":"2018-11-11T21:45:01","slug":"sql-server-2012de-kumulatif-toplam-nasil-alinir","status":"publish","type":"post","link":"https:\/\/www.yazilimmutfagi.com\/index.php\/2013\/01\/10\/sql-server-2012de-kumulatif-toplam-nasil-alinir\/","title":{"rendered":"SQL Server 2012&#8217;de K\u00fcm\u00fclatif Toplam Nasil Alinir."},"content":{"rendered":"\n<p><p>\n\tSQL Server 2012 den \u00f6nce k\u00fcm\u00fclatif toplama ihtiya duydugumuz zamanlar genelde i\u00e7 i\u00e7e sorgular yazar ve sonu\u00e7 elde etmeye \u00e7alisirdik. Sql Server 2012 ile artik k\u00fcm\u00fclatif toplam almak eskisi kadar zor degil.<\/p>\n<p>\n\tMicrosoft SQL Server 2012 de Window Function \u00f6zelliklerini gelistirerek, yeni \u00f6zellikler katmis. Ansi standartlarindan olan bu \u00f6zellikleri sonraki makalelerimizde detayli anlatacagim.<\/p>\n<p>\n\tBu makalemizde sadece kolayca k\u00fcm\u00fclatif toplam nasil aliniri g\u00f6sterecegim.<\/p>\n<p>\n\t<a href=\"http:\/\/www.yazilimmutfagi.com\/10145\/veritabani\/sql-server\/sql-serverda-kumulatif-toplam-nasil-alinir.aspx\">K\u00fcm\u00fclatif toplam i\u00e7in daha \u00f6nce yazdigim makaleye buradan ulasabilirsiniz.<\/a><\/p>\n<p>\n\tIlk olarak asagidaki sorguyu \u00e7alistirarak \u00f6rnek tablomuzu olusturalim.<\/p>\n<pre class=\"brush:sql\">create table Ornek_AylikGelir\n(\ntarih datetime,\nToplam int,\n)\n \ninsert into Ornek_AylikGelir(tarih,Toplam) values('2012.05.01',100)\ninsert into Ornek_AylikGelir(tarih,Toplam) values('2012.05.02',50)\ninsert into Ornek_AylikGelir(tarih,Toplam) values('2012.05.03',20)\ninsert into Ornek_AylikGelir(tarih,Toplam) values('2012.05.04',80)\ninsert into Ornek_AylikGelir(tarih,Toplam) values('2012.05.05',100)\ninsert into Ornek_AylikGelir(tarih,Toplam) values('2012.05.06',200)\n\n<\/pre>\n<p>\n\tAsagidaki sorgu ile tarihe g\u00f6re sirali olarak k\u00fcm\u00fclatif toplam almis oluruz.<\/p>\n<pre class=\"brush:sql\">select tarih,Toplam,sum(Toplam) over(order by tarih) as KumulatifToplam \nfrom Ornek_AylikGelir \n<\/pre>\n<p>\n\t<a href=\"http:\/\/www.yazilimmutfagi.com\/10145\/veritabani\/sql-server\/sql-serverda-kumulatif-toplam-nasil-alinir.aspx\">\u00d6nceki makalemizi<\/a> okursaniz 2012 den \u00f6nceki SQL Server versiyonlarinda bunu nasil yapacaginiz g\u00f6rebilirsiniz. Yukaridaki Sorgunun sonucu asagidaki gibi d\u00f6nmektedir.<\/p>\n<table class=\"reference\">\n\t<tbody>\n\t\t<tr>\n\t\t\t<th>\n\t\t\t\ttarih<\/th>\n\t\t\t<th>\n\t\t\t\tToplam<\/th>\n\t\t\t<th>\n\t\t\t\tKumulatifToplam<\/th>\n\t\t<\/tr>\n\t\t<tr>\n\t\t\t<td>\n\t\t\t\t2012-05-01 00:00:00.000<\/td>\n\t\t\t<td>\n\t\t\t\t100<\/td>\n\t\t\t<td>\n\t\t\t\t100<\/td>\n\t\t<\/tr>\n\t\t<tr>\n\t\t\t<td>\n\t\t\t\t2012-05-02 00:00:00.000<\/td>\n\t\t\t<td>\n\t\t\t\t50<\/td>\n\t\t\t<td>\n\t\t\t\t150<\/td>\n\t\t<\/tr>\n\t\t<tr>\n\t\t\t<td>\n\t\t\t\t2012-05-03 00:00:00.000<\/td>\n\t\t\t<td>\n\t\t\t\t20<\/td>\n\t\t\t<td>\n\t\t\t\t170<\/td>\n\t\t<\/tr>\n\t\t<tr>\n\t\t\t<td>\n\t\t\t\t2012-05-04 00:00:00.000<\/td>\n\t\t\t<td>\n\t\t\t\t80<\/td>\n\t\t\t<td>\n\t\t\t\t250<\/td>\n\t\t<\/tr>\n\t\t<tr>\n\t\t\t<td>\n\t\t\t\t2012-05-05 00:00:00.000<\/td>\n\t\t\t<td>\n\t\t\t\t100<\/td>\n\t\t\t<td>\n\t\t\t\t350<\/td>\n\t\t<\/tr>\n\t\t<tr>\n\t\t\t<td>\n\t\t\t\t2012-05-06 00:00:00.000<\/td>\n\t\t\t<td>\n\t\t\t\t200<\/td>\n\t\t\t<td>\n\t\t\t\t550<\/td>\n\t\t<\/tr>\n\t<\/tbody>\n<\/table>\n<p>\n\t&nbsp;<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server 2012 den &#246;nce k&#252;m&#252;latif toplama ihtiya duydugumuz zamanlar genelde i&#231; i&#231;e sorgular yazar ve sonu&#231; elde etmeye &#231;alisirdik. Sql Server 2012 ile artik k&#252;m&#252;latif toplam almak eskisi kadar zor degil.<\/p>\n","protected":false},"author":517,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[422],"tags":[4670,3900,4110,4851],"_links":{"self":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/321"}],"collection":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/users\/517"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/comments?post=321"}],"version-history":[{"count":2,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/321\/revisions"}],"predecessor-version":[{"id":4480,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/posts\/321\/revisions\/4480"}],"wp:attachment":[{"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/media?parent=321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/categories?post=321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yazilimmutfagi.com\/index.php\/wp-json\/wp\/v2\/tags?post=321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}