{"id":10318,"date":"2026-11-12T11:11:30","date_gmt":"2026-11-12T08:11:30","guid":{"rendered":"https:\/\/www.yunuskaytan.com\/?p=10318"},"modified":"2026-11-12T11:11:30","modified_gmt":"2026-11-12T08:11:30","slug":"sql-group-by-ve-having-farki","status":"publish","type":"post","link":"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-group-by-ve-having-farki\/","title":{"rendered":"SQL GROUP BY ve HAVING Fark\u0131"},"content":{"rendered":"<p class=\"wp-block-paragraph\">\u0130li\u015fkisel veritaban\u0131 y\u00f6netim sistemlerinde (RDBMS) verileri yaln\u0131zca sat\u0131r baz\u0131nda okumak \u00e7o\u011fu zaman i\u015f ihtiya\u00e7lar\u0131n\u0131 kar\u015f\u0131lamaz. B\u00fcy\u00fck veri y\u0131\u011f\u0131nlar\u0131 i\u00e7erisinden \u00f6zet raporlar \u00e7\u0131karmak, departman bazl\u0131 maa\u015f ortalamalar\u0131n\u0131 g\u00f6rmek ya da belirli bir tutar\u0131n \u00fczerinde sipari\u015f veren m\u00fc\u015fterileri tespit etmek gibi i\u015flemler i\u00e7in toplu veri analizi gerekir. Bu noktada SQL dilinin en temel fonksiyonel yap\u0131 ta\u015flar\u0131ndan olan GROUP BY ve HAVING devreye girer.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Yeni ba\u015flayanlar\u0131n s\u0131kl\u0131kla kar\u0131\u015ft\u0131rd\u0131\u011f\u0131 bu iki kavram, veriyi yap\u0131land\u0131rma ve filtreleme s\u00fcre\u00e7lerinde tamamen farkl\u0131 a\u015famalarda rol oynar. Bu rehberde, GROUP BY ve HAVING ifadelerinin teknik farklar\u0131n\u0131, \u00e7al\u0131\u015fma mant\u0131klar\u0131n\u0131 ve do\u011fru kullan\u0131m y\u00f6ntemlerini ad\u0131m ad\u0131m inceleyece\u011fiz.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL&#8217;de Gruplama Mant\u0131\u011f\u0131 Nedir?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Gruplama, bir tablodaki birden fazla sat\u0131r\u0131n ortak bir veya birka\u00e7 s\u00fctun de\u011ferine g\u00f6re sanal olarak bir araya getirilmesi i\u015flemidir. Tek tek sat\u0131rlar\u0131 incelemek yerine, olu\u015fan her bir grubu tek bir sat\u0131rm\u0131\u015f gibi temsil eden \u00f6zet de\u011ferler hesaplan\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bu \u00f6zet hesaplamalar SQL&#8217;de &#8220;Aggregate Functions&#8221; (Toplama\/K\u00fcmeleme Fonksiyonlar\u0131) olarak bilinen yap\u0131lar ile ger\u00e7ekle\u015ftirilir:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>COUNT(): Belirli bir gruptaki sat\u0131r say\u0131s\u0131n\u0131 hesaplar.<\/li>\n\n<li>SUM(): Say\u0131sal bir s\u00fctunun toplam de\u011ferini bulur.<\/li>\n\n<li>AVG(): Say\u0131sal bir s\u00fctunun aritmetik ortalamas\u0131n\u0131 hesaplar.<\/li>\n\n<li>MIN(): Gruptaki en k\u00fc\u00e7\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/li>\n\n<li>MAX(): Gruptaki en b\u00fcy\u00fck de\u011feri d\u00f6nd\u00fcr\u00fcr.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">GROUP BY \u0130fadesinin Kullan\u0131m\u0131<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">GROUP BY ifadesi, se\u00e7ilen s\u00fctunlardaki ayn\u0131 de\u011ferlere sahip sat\u0131rlar\u0131 \u00f6zet sat\u0131rlarda birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r. Tek ba\u015f\u0131na bir filtreleme mekanizmas\u0131 de\u011fildir; veriyi s\u0131n\u0131fland\u0131rma ve b\u00f6l\u00fcmlere ay\u0131rma arac\u0131d\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A\u015fa\u011f\u0131daki \u00f6rnek i\u00e7in bir e-ticaret sistemindeki &#8220;Siparisler&#8221; tablosunu ele alal\u0131m. Bu tabloda MusteriID, Kategori ve Tutar alanlar\u0131 bulunsun:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Kategori, COUNT(*) AS ToplamSiparis, SUM(Tutar) AS ToplamCiro\nFROM Siparisler\nGROUP BY Kategori;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Yukar\u0131daki sorgunun yapt\u0131\u011f\u0131 i\u015flem ad\u0131mlar\u0131 \u015funlard\u0131r:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Veritaban\u0131 motoru tablodaki t\u00fcm sat\u0131rlar\u0131 tarar.<\/li>\n\n<li>Ayn\u0131 Kategori de\u011ferine sahip sat\u0131rlar\u0131 sanal gruplar haline getirir.<\/li>\n\n<li>Her kategori i\u00e7in sipari\u015f adedini (COUNT) ve bu kategorideki toplam harcamay\u0131 (SUM) hesaplar.<\/li>\n\n<li>Sonu\u00e7 k\u00fcmesinde her benzersiz kategori i\u00e7in tek bir sat\u0131r \u00fcretilir.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">HAVING \u0130fadesinin Rol\u00fc<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">HAVING, gruplanm\u0131\u015f veri k\u00fcmeleri \u00fczerinde filtreleme yapmak i\u00e7in kullan\u0131l\u0131r. Standart filtreleme arac\u0131 olan WHERE ifadesi, aggregate (k\u00fcmeleme) fonksiyonlar\u0131yla birlikte do\u011frudan kullan\u0131lamaz. \u00c7\u00fcnk\u00fc WHERE, veritaban\u0131 motoru sat\u0131rlar\u0131 gruplamadan \u00f6nce \u00e7al\u0131\u015f\u0131r. Sat\u0131rlar hen\u00fcz gruplanmad\u0131\u011f\u0131 i\u00e7in &#8220;toplam\u0131 5000&#8217;den b\u00fcy\u00fck olan kategoriler&#8221; gibi bir \u015fart\u0131 WHERE ile s\u0131namak m\u00fcmk\u00fcn de\u011fildir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">HAVING tam olarak bu sorunu \u00e7\u00f6zer. GROUP BY i\u015fleminden sonra olu\u015fan sanal gruplara ko\u015ful uygular ve yaln\u0131zca belirtilen kritere uyan gruplar\u0131n sonu\u00e7 tablosunda kalmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Kategori, SUM(Tutar) AS ToplamCiro\nFROM Siparisler\nGROUP BY Kategori\nHAVING SUM(Tutar) &gt; 50000;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu sorguda i\u015flem \u015fu \u015fekilde y\u00fcr\u00fct\u00fcl\u00fcr:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Veriler Kategori alan\u0131na g\u00f6re gruplan\u0131r.<\/li>\n\n<li>Her grubun toplam cirosu SUM(Tutar) ile hesaplan\u0131r.<\/li>\n\n<li>HAVING ifadesi devreye girerek toplam cirosu 50.000 birimin alt\u0131nda kalan kategorileri sonu\u00e7 k\u00fcmesinden eler.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">GROUP BY ve HAVING Aras\u0131ndaki Temel Farklar<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0130ki ifadenin \u00e7al\u0131\u015fma alanlar\u0131 ve sorumluluklar\u0131 kesin \u00e7izgilerle ayr\u0131lm\u0131\u015ft\u0131r:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>GROUP BY sat\u0131rlar\u0131 mant\u0131ksal gruplara ay\u0131r\u0131r, tek ba\u015f\u0131na bir eleme veya \u00e7\u0131karma i\u015flemi yapmaz.<\/li>\n\n<li>HAVING gruplanm\u0131\u015f verileri filtreler, belirlenen ko\u015fulu sa\u011flamayan gruplar\u0131 sonu\u00e7tan d\u0131\u015flar.<\/li>\n\n<li>GROUP BY s\u00fctun adlar\u0131yla \u00e7al\u0131\u015f\u0131rken, HAVING genellikle COUNT, SUM, AVG gibi k\u00fcmeleme fonksiyonlar\u0131yla olu\u015fturulan mant\u0131ksal ko\u015fullarla birlikte \u00e7al\u0131\u015f\u0131r.<\/li>\n\n<li>Sorgu i\u00e7inde GROUP BY kullan\u0131lmadan HAVING kullan\u0131m\u0131 standart SQL mant\u0131\u011f\u0131nda nadiren ge\u00e7erlidir; HAVING varl\u0131\u011f\u0131n\u0131 gruplara bor\u00e7ludur.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">WHERE ile HAVING Aras\u0131ndaki Fark<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Konunun tam anla\u015f\u0131lmas\u0131 i\u00e7in WHERE ve HAVING ayr\u0131m\u0131n\u0131 da netle\u015ftirmek gerekir. \u0130kisi de filtreleme yapar ancak \u00e7al\u0131\u015ft\u0131klar\u0131 zamanlama farkl\u0131d\u0131r:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>WHERE ifadesi sat\u0131r bazl\u0131 filtreleme yapar. Gruplama i\u015fleminden \u00f6nce \u00e7al\u0131\u015f\u0131r ve \u015fart\u0131 sa\u011flamayan sat\u0131rlar\u0131 hen\u00fcz gruplamaya dahil edilmeden eler.<\/li>\n\n<li>HAVING ifadesi grup bazl\u0131 filtreleme yapar. Gruplama tamamland\u0131ktan ve aggregate fonksiyonlar\u0131 hesapland\u0131ktan sonra \u00e7al\u0131\u015f\u0131r.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Bu iki yap\u0131n\u0131n birlikte kullan\u0131ld\u0131\u011f\u0131 geli\u015fmi\u015f bir senaryoya bakal\u0131m:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT Kategori, AVG(Tutar) AS OrtalamaTutar\nFROM Siparisler\nWHERE Durum = 'Tamamlandi'\nGROUP BY Kategori\nHAVING AVG(Tutar) &gt;= 1000;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Bu sorgunun icra s\u0131ras\u0131 \u015f\u00f6yledir:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0130lk olarak FROM ile Siparisler tablosuna eri\u015filir.<\/li>\n\n<li>WHERE ko\u015fulu i\u015fletilir; Durum s\u00fctunu &#8216;Tamamlandi&#8217; olmayan t\u00fcm sat\u0131rlar do\u011frudan at\u0131l\u0131r.<\/li>\n\n<li>Kalan ge\u00e7erli sat\u0131rlar Kategori s\u00fctununa g\u00f6re GROUP BY ile k\u00fcmelenir.<\/li>\n\n<li>Her kategori i\u00e7in AVG(Tutar) hesaplan\u0131r.<\/li>\n\n<li>HAVING devreye girerek ortalama tutar\u0131 1000&#8217;in alt\u0131nda olan kategorileri eler.<\/li>\n\n<li>SELECT ile kriterleri ge\u00e7en kategoriler ve hesaplanan ortalamalar listelenir.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">S\u0131k Kar\u015f\u0131la\u015f\u0131lan Hatalar ve Dikkat Edilmesi Gerekenler<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">SQL sorgular\u0131 yazarken performans ve s\u00f6zdizimi a\u00e7\u0131s\u0131ndan dikkat edilmesi gereken kritik noktalar bulunur:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SELECT yan t\u00fcmcesinde yer alan ve herhangi bir aggregate fonksiyonu i\u00e7inde bulunmayan t\u00fcm s\u00fctunlar, mutlaka GROUP BY yan t\u00fcmcesinde de a\u00e7\u0131k\u00e7a belirtilmelidir. Aksi takdirde RDBMS derleyicisi s\u00f6zdizimi hatas\u0131 verir.<\/li>\n\n<li>Sat\u0131r baz\u0131nda yap\u0131labilecek filtrelemeleri HAVING i\u00e7erisine ta\u015f\u0131mak performans\u0131 olumsuz etkiler. \u00d6rne\u011fin kategori ad\u0131n\u0131 HAVING Kategori = &#8216;Elektronik&#8217; \u015feklinde yazmak yerine WHERE Kategori = &#8216;Elektronik&#8217; \u015feklinde yazmak gerekir. WHERE, sat\u0131rlar\u0131 gruplama i\u015flemine sokmadan \u00f6nce eleyerek bellek ve i\u015flemci tasarrufu sa\u011flar.<\/li>\n\n<li>HAVING yaln\u0131zca gruplanm\u0131\u015f veriyi veya aggregate fonksiyon sonu\u00e7lar\u0131n\u0131 filtrelemek i\u00e7in tercih edilmelidir.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u00d6zet ve Sonraki Ad\u0131mlar<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">GROUP BY verileri s\u0131n\u0131fland\u0131rarak \u00f6zet bilgi \u00fcretmek i\u00e7in zemin haz\u0131rlar; HAVING ise bu \u00f6zet bilgiler \u00fczerinden filtre uygulama imkan\u0131 sunar. Birlikte kullan\u0131ld\u0131klar\u0131nda b\u00fcy\u00fck veri k\u00fcmelerinden hedefe y\u00f6nelik analitik raporlar elde etmeyi sa\u011flarlar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bir sonraki ad\u0131m olarak, veritaban\u0131n\u0131zda birden fazla s\u00fctuna g\u00f6re gruplama (GROUP BY Kategori, Bolge) senaryolar\u0131n\u0131 test edebilir ve HAVING ile COUNT(*) gibi farkl\u0131 fonksiyonlar\u0131 birle\u015ftirerek pratik sorgular kurgulayabilirsiniz.<\/p>","protected":false},"excerpt":{"rendered":"<p>SQL sorgular\u0131nda veri k\u00fcmeleme ve filtrelenmi\u015f grup y\u00f6netimi i\u00e7in kullan\u0131lan GROUP BY ile HAVING ifadelerinin farklar\u0131n\u0131 ve \u00e7al\u0131\u015fma prensiplerini inceleyin.<\/p>","protected":false},"author":1,"featured_media":10319,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[230],"tags":[588,254,609,601,257],"class_list":["post-10318","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-veritabani","tag-rdbms","tag-sql","tag-sql-group-by-having","tag-sql-sorgulari","tag-veritabani"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL GROUP BY ve HAVING Fark\u0131 - Yunus KAYTAN<\/title>\n<meta name=\"description\" content=\"SQL GROUP BY ve HAVING ifadelerinin farklar\u0131n\u0131, kullan\u0131m alanlar\u0131n\u0131 ve filtreleme mant\u0131\u011f\u0131n\u0131 detayl\u0131 kod \u00f6rnekleriyle \u00f6\u011frenin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-group-by-ve-having-farki\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL GROUP BY ve HAVING Fark\u0131 - Yunus KAYTAN\" \/>\n<meta property=\"og:description\" content=\"SQL GROUP BY ve HAVING ifadelerinin farklar\u0131n\u0131, kullan\u0131m alanlar\u0131n\u0131 ve filtreleme mant\u0131\u011f\u0131n\u0131 detayl\u0131 kod \u00f6rnekleriyle \u00f6\u011frenin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-group-by-ve-having-farki\/\" \/>\n<meta property=\"og:site_name\" content=\"Yunus KAYTAN\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-12T08:11:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-group-by-ve-having-farki-kapak.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yunuskaytan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yunuskaytan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/\"},\"author\":{\"name\":\"yunuskaytan\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/person\\\/be66986fb499da83a5685de34f68d15a\"},\"headline\":\"SQL GROUP BY ve HAVING Fark\u0131\",\"datePublished\":\"2026-11-12T08:11:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/\"},\"wordCount\":1024,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-group-by-ve-having-farki-kapak.jpg\",\"keywords\":[\"rdbms\",\"sql\",\"sql group by having\",\"sql sorgulari\",\"veritaban\u0131\"],\"articleSection\":[\"Veritaban\u0131\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/\",\"name\":\"SQL GROUP BY ve HAVING Fark\u0131 - Yunus KAYTAN\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-group-by-ve-having-farki-kapak.jpg\",\"datePublished\":\"2026-11-12T08:11:30+00:00\",\"description\":\"SQL GROUP BY ve HAVING ifadelerinin farklar\u0131n\u0131, kullan\u0131m alanlar\u0131n\u0131 ve filtreleme mant\u0131\u011f\u0131n\u0131 detayl\u0131 kod \u00f6rnekleriyle \u00f6\u011frenin.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-group-by-ve-having-farki-kapak.jpg\",\"contentUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/blog-kapak\\\/sql-group-by-ve-having-farki-kapak.jpg\",\"width\":1200,\"height\":630,\"caption\":\"SQL GROUP BY ve HAVING Fark\u0131\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/yk\\\/sql-group-by-ve-having-farki\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\\\/\\\/www.yunuskaytan.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL GROUP BY ve HAVING Fark\u0131\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#website\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/\",\"name\":\"Yunus KAYTAN\",\"description\":\"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yunuskaytan.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#organization\",\"name\":\"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-BILISIM-VE-SIBER-GUVENLIK.png\",\"contentUrl\":\"https:\\\/\\\/www.yunuskaytan.com\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/cropped-BILISIM-VE-SIBER-GUVENLIK.png\",\"width\":400,\"height\":109,\"caption\":\"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yunuskaytan.com\\\/#\\\/schema\\\/person\\\/be66986fb499da83a5685de34f68d15a\",\"name\":\"yunuskaytan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g\",\"caption\":\"yunuskaytan\"},\"sameAs\":[\"http:\\\/\\\/www.yunuskaytan.com\"],\"url\":\"https:\\\/\\\/www.yunuskaytan.com\\\/en\\\/yk\\\/author\\\/yunuskaytan\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL GROUP BY ve HAVING Fark\u0131 - Yunus KAYTAN","description":"SQL GROUP BY ve HAVING ifadelerinin farklar\u0131n\u0131, kullan\u0131m alanlar\u0131n\u0131 ve filtreleme mant\u0131\u011f\u0131n\u0131 detayl\u0131 kod \u00f6rnekleriyle \u00f6\u011frenin.","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:\/\/www.yunuskaytan.com\/en\/yk\/sql-group-by-ve-having-farki\/","og_locale":"en_US","og_type":"article","og_title":"SQL GROUP BY ve HAVING Fark\u0131 - Yunus KAYTAN","og_description":"SQL GROUP BY ve HAVING ifadelerinin farklar\u0131n\u0131, kullan\u0131m alanlar\u0131n\u0131 ve filtreleme mant\u0131\u011f\u0131n\u0131 detayl\u0131 kod \u00f6rnekleriyle \u00f6\u011frenin.","og_url":"https:\/\/www.yunuskaytan.com\/en\/yk\/sql-group-by-ve-having-farki\/","og_site_name":"Yunus KAYTAN","article_published_time":"2026-11-12T08:11:30+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-group-by-ve-having-farki-kapak.jpg","type":"image\/jpeg"}],"author":"yunuskaytan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yunuskaytan","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/#article","isPartOf":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/"},"author":{"name":"yunuskaytan","@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/person\/be66986fb499da83a5685de34f68d15a"},"headline":"SQL GROUP BY ve HAVING Fark\u0131","datePublished":"2026-11-12T08:11:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/"},"wordCount":1024,"commentCount":0,"publisher":{"@id":"https:\/\/www.yunuskaytan.com\/#organization"},"image":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-group-by-ve-having-farki-kapak.jpg","keywords":["rdbms","sql","sql group by having","sql sorgulari","veritaban\u0131"],"articleSection":["Veritaban\u0131"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/","url":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/","name":"SQL GROUP BY ve HAVING Fark\u0131 - Yunus KAYTAN","isPartOf":{"@id":"https:\/\/www.yunuskaytan.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/#primaryimage"},"image":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-group-by-ve-having-farki-kapak.jpg","datePublished":"2026-11-12T08:11:30+00:00","description":"SQL GROUP BY ve HAVING ifadelerinin farklar\u0131n\u0131, kullan\u0131m alanlar\u0131n\u0131 ve filtreleme mant\u0131\u011f\u0131n\u0131 detayl\u0131 kod \u00f6rnekleriyle \u00f6\u011frenin.","breadcrumb":{"@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/#primaryimage","url":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-group-by-ve-having-farki-kapak.jpg","contentUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/blog-kapak\/sql-group-by-ve-having-farki-kapak.jpg","width":1200,"height":630,"caption":"SQL GROUP BY ve HAVING Fark\u0131"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yunuskaytan.com\/yk\/sql-group-by-ve-having-farki\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/www.yunuskaytan.com\/"},{"@type":"ListItem","position":2,"name":"SQL GROUP BY ve HAVING Fark\u0131"}]},{"@type":"WebSite","@id":"https:\/\/www.yunuskaytan.com\/#website","url":"https:\/\/www.yunuskaytan.com\/","name":"Yunus KAYTAN","description":"Information Technology, Cybersecurity, Cybercrimes and Social Engineering","publisher":{"@id":"https:\/\/www.yunuskaytan.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yunuskaytan.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.yunuskaytan.com\/#organization","name":"Information Technology, Cybersecurity, Cybercrimes and Social Engineering","url":"https:\/\/www.yunuskaytan.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/2021\/07\/cropped-BILISIM-VE-SIBER-GUVENLIK.png","contentUrl":"https:\/\/www.yunuskaytan.com\/wp-content\/uploads\/2021\/07\/cropped-BILISIM-VE-SIBER-GUVENLIK.png","width":400,"height":109,"caption":"Bili\u015fim, Siber G\u00fcvenlik, Siber Su\u00e7lar ve Sosyal M\u00fchendislik"},"image":{"@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.yunuskaytan.com\/#\/schema\/person\/be66986fb499da83a5685de34f68d15a","name":"yunuskaytan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3caae7a5e52b2c1df0cbbb777ba7b421ad4777ac947e9320b5809e2d454ffdb4?s=96&d=mm&r=g","caption":"yunuskaytan"},"sameAs":["http:\/\/www.yunuskaytan.com"],"url":"https:\/\/www.yunuskaytan.com\/en\/yk\/author\/yunuskaytan\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts\/10318","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/comments?post=10318"}],"version-history":[{"count":1,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts\/10318\/revisions"}],"predecessor-version":[{"id":10320,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/posts\/10318\/revisions\/10320"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/media\/10319"}],"wp:attachment":[{"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/media?parent=10318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/categories?post=10318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yunuskaytan.com\/en\/wp-json\/wp\/v2\/tags?post=10318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}