{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"SQL'de Gruplama \u0130fadeleri: Veri Analizinin Temeli","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"yrL9A0ZLMA\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sqlde-gruplama-ifadeleri-veri-analizinin-temeli\/\">SQL&#8217;de Gruplama \u0130fadeleri: Veri Analizinin Temeli<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sqlde-gruplama-ifadeleri-veri-analizinin-temeli\/embed\/#?secret=yrL9A0ZLMA\" width=\"600\" height=\"338\" title=\"&#8220;SQL&#8217;de Gruplama \u0130fadeleri: Veri Analizinin Temeli&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"yrL9A0ZLMA\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"Veri analizi s\u00fcrecinde, verileri anlaml\u0131 gruplara ay\u0131rmak ve bu gruplar \u00fczerinde toplu i\u015flemler yapmak olduk\u00e7a \u00f6nemlidir. SQL'de bu i\u015flemi sa\u011flayan g\u00fc\u00e7l\u00fc bir ara\u00e7 \"GROUP BY\" deyimidir. Bu makalede, SQL'deki GROUP BY ifadesini detayl\u0131 olarak ele alacak, farkl\u0131 kullan\u0131m senaryolar\u0131n\u0131 inceleyecek ve pratik \u00f6rneklerle peki\u015ftirece\u011fiz. Ayn\u0131 zamanda, GROUP BY ile birlikte kullan\u0131lan di\u011fer fonksiyonlar\u0131 da a\u00e7\u0131klayaca\u011f\u0131z. Anlayaca\u011f\u0131n\u0131z \u00fczere, bu makale veri analiziyle ilgilenen herkes i\u00e7in olduk\u00e7a faydal\u0131 bilgiler sunacak."}