{"id":921,"date":"2020-02-10T21:13:51","date_gmt":"2020-02-10T18:13:51","guid":{"rendered":"http:\/\/www.aydiner.gen.tr\/?p=921"},"modified":"2023-04-23T20:33:45","modified_gmt":"2023-04-23T17:33:45","slug":"sql-count-max-min-sum-avg-fonksiyonlarinin-group-by-ile-kullanimi","status":"publish","type":"post","link":"https:\/\/www.aydiner.gen.tr\/index.php\/2020\/02\/10\/sql-count-max-min-sum-avg-fonksiyonlarinin-group-by-ile-kullanimi\/","title":{"rendered":"Sql (Count, Max, Min, Sum, Avg) Fonksiyonlar\u0131n\u0131n Group By \u0130le Kullan\u0131m\u0131"},"content":{"rendered":"<p><a href=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2020\/01\/sql.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft  wp-image-903\" src=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2020\/01\/sql-300x243.png\" alt=\"\" width=\"141\" height=\"114\" \/><\/a><\/p>\n<p>Sql ile basit sorgular \u00f6\u011frenildikten sonra istatistiki raporlamalar i\u00e7in Count, Max, Min, Sum ve Avg fonksiyonlar\u0131n\u0131n mutlaka bilinmesi gerekir. GROUP BY deyimi ise genellikle sonu\u00e7 k\u00fcmesini bir veya daha fazla s\u00fctunla gruplamak i\u00e7in (Count, Max, Min, Sum, Avg) ile birlikte kullan\u0131l\u0131r.<\/p>\n<p>Sorgular\u0131 daha iyi anlamak i\u00e7in a\u015fa\u011f\u0131daki\u00a0<strong>calisanlar<\/strong>\u00a0tablosunu kullanaca\u011f\u0131z.<\/p>\n<div class=\"google-auto-placed ap_container\"><\/div>\n<p><!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-1734 lazyloaded tie-appear\" src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-calisanlar-600x216.jpg\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-calisanlar-600x216.jpg 600w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-calisanlar-300x108.jpg 300w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-calisanlar.jpg 732w\" alt=\"\" width=\"600\" height=\"216\" data-srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-calisanlar-600x216.jpg 600w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-calisanlar-300x108.jpg 300w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-calisanlar.jpg 732w\" data-src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-calisanlar-600x216.jpg\" \/><\/p>\n<h2>Count Deyiminin Group By ile Kullan\u0131m\u0131<\/h2>\n<p>Count() metodu belirtilen kriterlere uyan kay\u0131tlar\u0131n say\u0131s\u0131n\u0131 verir.<\/p>\n<p>Soru: Her ilde \u00e7al\u0131\u015fan i\u015f\u00e7i say\u0131lar\u0131n\u0131 listeleyiniz.<\/p>\n<div class=\"one_half\">\n<p>SELECT adres,count(Id) AS \u201c\u00c7al\u0131\u015fan Say\u0131s\u0131\u201d<\/p>\n<p>FROM calisanlar<\/p>\n<p>GROUP BY adres<\/p>\n<\/div>\n<div class=\"one_half last\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1733 lazyloaded tie-appear\" src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-count.jpg\" sizes=\"auto, (max-width: 200px) 100vw, 200px\" srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-count.jpg 200w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-count-110x75.jpg 110w\" alt=\"\" width=\"200\" height=\"134\" data-srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-count.jpg 200w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-count-110x75.jpg 110w\" data-src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-count.jpg\" \/><\/p>\n<\/div>\n<div class=\"clear\"><\/div>\n<p>E\u011fer ildeki \u00e7al\u0131\u015fan say\u0131lar\u0131na g\u00f6re s\u0131ralama yapacak olsayd\u0131k sorgunun sonuna ORDER BY count(id) desc komutunu eklememiz gerekirdi.<\/p>\n<h2>Max Deyiminin Group By ile Kullan\u0131m\u0131<\/h2>\n<p>Max(): Se\u00e7ilen s\u00fctunun en b\u00fcy\u00fck de\u011ferini verir.<\/p>\n<p>Soru: En y\u00fcksek maa\u015f\u0131 alan erkek ve kad\u0131n \u00e7al\u0131\u015fanlar\u0131n bilgilerini listeleyiniz.<\/p>\n<div class=\"one_half\">\n<p>SELECT ad,soyad,cinsiyet,max(maas) AS maas<\/p>\n<p>FROM calisanlar<\/p>\n<p>GROUP BY cinsiyet<\/p>\n<div id=\"quads-ad2\" class=\"quads-location quads-ad2\"><ins class=\"adsbygoogle\" data-ad-client=\"ca-pub-5287131492316638\" data-ad-slot=\"7424864537\" data-adsbygoogle-status=\"done\"><ins id=\"aswift_2_expand\"><ins id=\"aswift_2_anchor\"><iframe width=\"0\" height=\"0\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" vspace=\"0\" hspace=\"0\" allowtransparency=\"true\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\" onload=\"var i=this.id,s=window.google_iframe_oncopy,H=s&amp;&amp;s.handlers,h=H&amp;&amp;H[i],w=this.contentWindow,d;try{d=w.document}catch(e){}if(h&amp;&amp;d&amp;&amp;(!d.body||!d.body.firstChild)){if(h.call){setTimeout(h,0)}else if(h.match){try{h=s.upd(h,i)}catch(e){}w.location.replace(h)}}\" id=\"aswift_2\" name=\"aswift_2\" data-mce-fragment=\"1\"><\/iframe><\/ins><\/ins><\/ins><\/div>\n<\/div>\n<div class=\"one_half last\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1735 lazyloaded tie-appear\" src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-max.jpg\" sizes=\"auto, (max-width: 316px) 100vw, 316px\" srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-max.jpg 316w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-max-300x64.jpg 300w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-max-310x67.jpg 310w\" alt=\"\" width=\"316\" height=\"67\" data-srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-max.jpg 316w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-max-300x64.jpg 300w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-max-310x67.jpg 310w\" data-src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-max.jpg\" \/><\/p>\n<\/div>\n<div class=\"clear\"><\/div>\n<p>&nbsp;<\/p>\n<h2>Min Deyiminin Group By ile Kullan\u0131m\u0131<\/h2>\n<p>Min(): Se\u00e7ilen s\u00fctunun en k\u00fc\u00e7\u00fck de\u011ferini verir.<\/p>\n<p>Soru: \u0130llerde ki en d\u00fc\u015f\u00fck maa\u015flar\u0131 listeleyiniz.<\/p>\n<div class=\"one_half\">\n<p>SELECT adres, min(maas) AS maa\u015f<\/p>\n<p>FROM calisanlar<\/p>\n<p>GROUP BY adres<\/p>\n<\/div>\n<div class=\"one_half last\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1736 lazyloaded tie-appear\" src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-min.jpg\" alt=\"\" width=\"170\" height=\"133\" data-src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-min.jpg\" \/><\/p>\n<\/div>\n<div class=\"clear\"><\/div>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2>Sum Deyiminin Group By ile Kullan\u0131m\u0131<\/h2>\n<p>Sum(): Se\u00e7ilen s\u00fctunun de\u011ferlerinin toplam\u0131n\u0131 verir.<\/p>\n<p>Soru: Bir y\u0131lda \u00f6denen toplam maa\u015f miktar\u0131n\u0131 cinsiyete g\u00f6re listeleyiniz.<\/p>\n<div class=\"one_half\">\n<p>SELECT cinsiyet, sum(maas) AS maa\u015f<\/p>\n<p>FROM calisanlar<\/p>\n<p>GROUP BY cinsiyet<\/p>\n<\/div>\n<div class=\"one_half last\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1737 lazyloaded tie-appear\" src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-sum.jpg\" alt=\"\" width=\"175\" height=\"75\" data-src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-sum.jpg\" \/><\/p>\n<\/div>\n<div class=\"clear\"><\/div>\n<p>&nbsp;<\/p>\n<h2>Avg Deyiminin Group By ile Kullan\u0131m\u0131<\/h2>\n<p>Avg(): Se\u00e7ilen s\u00fctunun de\u011ferlerinin ortalamas\u0131n\u0131 verir.<\/p>\n<p>Soru: Bir y\u0131lda \u00f6denen maa\u015flar\u0131n illere g\u00f6re ortalamas\u0131n\u0131 listeleyiniz.<\/p>\n<div class=\"one_half\">\n<p>SELECT adres, avg(maas) AS ortalama<\/p>\n<p>FROM calisanlar<\/p>\n<p>GROUP BY adres<\/p>\n<\/div>\n<div class=\"one_half last\">\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1732 lazyloaded tie-appear\" src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-avg.jpg\" sizes=\"auto, (max-width: 192px) 100vw, 192px\" srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-avg.jpg 192w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-avg-110x75.jpg 110w\" alt=\"\" width=\"192\" height=\"131\" data-srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-avg.jpg 192w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-avg-110x75.jpg 110w\" data-src=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2018\/12\/sql-avg.jpg\" \/><\/p>\n<\/div>\n<div class=\"clear\"><\/div>\n<p>&nbsp;<\/p>\n<p>Tablolar aras\u0131 ili\u015fkiler karma\u015f\u0131kla\u015ft\u0131k\u00e7a ve tablolarda ki kay\u0131t say\u0131s\u0131 art\u0131k\u00e7a Count, Max, Min, Sum, Avg metotlar\u0131n\u0131n istatistiki veri toplamada \u00f6nemi artmaktad\u0131r.<\/p>\n<p><a href=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2020\/01\/sql.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft  wp-image-903\" src=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2020\/01\/sql-300x243.png\" alt=\"\" width=\"163\" height=\"132\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sql ile basit sorgular \u00f6\u011frenildikten sonra istatistiki raporlamalar i\u00e7in Count, Max, Min, Sum ve Avg fonksiyonlar\u0131n\u0131n mutlaka bilinmesi gerekir. GROUP [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[180],"tags":[],"class_list":["post-921","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/comments?post=921"}],"version-history":[{"count":1,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/921\/revisions"}],"predecessor-version":[{"id":2139,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/921\/revisions\/2139"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}