{"id":14737,"date":"2025-03-10T06:00:14","date_gmt":"2025-03-10T03:00:14","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/"},"modified":"2025-03-10T06:00:14","modified_gmt":"2025-03-10T03:00:14","slug":"sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/","title":{"rendered":"SQL&#8217;den SPL&#8217;ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma"},"content":{"rendered":"<p><body><\/p>\n<p>SQL&#8217;den SPL&#8217;ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma<\/p>\n<p>Veri i\u015flemede s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir durum, bir veritaban\u0131ndaki kay\u0131tlar\u0131 grupland\u0131rarak bu gruplar \u00fczerinde hesaplamalar yapma ve sonucu ilk kayda yazma ihtiyac\u0131d\u0131r.  Bu makalede, SQL&#8217;den SPL&#8217;ye ge\u00e7i\u015fi ele alarak, bu i\u015flemin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131z. \u00d6ncelikle SQL&#8217;de nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6rece\u011fiz, ard\u0131ndan SPL&#8217;deki e\u015fde\u011ferini inceleyip kar\u015f\u0131la\u015ft\u0131raca\u011f\u0131z.  Sonras\u0131nda ise,  pratik \u00f6rneklerle konuyu daha iyi kavrayaca\u011f\u0131z.<\/p>\n<h2>SQL ile Grup \u0130\u00e7i Hesaplamalar<\/h2>\n<p>SQL&#8217;de, gruplama i\u015flemleri GROUP BY deyimi ile yap\u0131l\u0131r.  Toplam, ortalama gibi agregasyon fonksiyonlar\u0131n\u0131 kullanarak grup i\u00e7i hesaplamalar ger\u00e7ekle\u015ftiririz.  Ancak, sonucu ilk kayda yazmak i\u00e7in biraz daha karma\u015f\u0131k sorgular kullanmam\u0131z gerekir.  \u00d6rne\u011fin, m\u00fc\u015fterilerin sipari\u015f toplamlar\u0131n\u0131 hesaplay\u0131p ilk sipari\u015f kayd\u0131na yazmak istedi\u011fimizi d\u00fc\u015f\u00fcnelim.<\/p>\n<pre><code class=\"language-sql\">\nSELECT\n    m.musteri_id,\n    m.musteri_adi,\n    SUM(s.siparis_tutari) OVER (PARTITION BY m.musteri_id) as toplam_siparis_tutari\nFROM\n    musteriler m\nJOIN\n    siparisler s ON m.musteri_id = s.musteri_id\nGROUP BY\n    m.musteri_id, m.musteri_adi, s.siparis_tutari\nORDER BY\n    m.musteri_id;\n<\/code><\/pre>\n<p>Bu sorgu, her m\u00fc\u015fteri i\u00e7in sipari\u015f toplamlar\u0131n\u0131 hesaplar ancak her sipari\u015f kayd\u0131 i\u00e7in bu toplam\u0131 tekrarlar.  \u0130lk kayda yazmak i\u00e7in, daha geli\u015fmi\u015f pencere fonksiyonlar\u0131 veya alt sorgular kullanmak gerekebilir.  Bu durum, sorgular\u0131n karma\u015f\u0131kl\u0131\u011f\u0131n\u0131 ve performans\u0131n\u0131 olumsuz etkileyebilir.  \u0130\u015fte bu noktada SPL devreye giriyor.<\/p>\n<h2>SPL ile Daha Verimli \u00c7\u00f6z\u00fcm<\/h2>\n<p>SPL (Stream Processing Language),  veri ak\u0131\u015flar\u0131n\u0131 i\u015flemek i\u00e7in tasarlanm\u0131\u015f, SQL&#8217;e g\u00f6re daha sade ve verimli bir dildir.  Grup i\u00e7i hesaplamalar ve ilk kayda yazma i\u015flemi SPL ile olduk\u00e7a kolayla\u015f\u0131r.  A\u015fa\u011f\u0131daki \u00f6rnek, ayn\u0131 i\u015flemi SPL ile nas\u0131l ger\u00e7ekle\u015ftirebilece\u011fimizi g\u00f6steriyor.<\/p>\n<pre><code class=\"language-spl\">\ndata = load 'siparisler';\ngrouped_data = group data by musteri_id;\nresult = foreach grouped_data generate musteri_id, sum(siparis_tutari) as toplam_siparis_tutari;\nstore result into 'sonuclar';\n<\/code><\/pre>\n<p>G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi, SPL kodu \u00e7ok daha okunakl\u0131 ve anla\u015f\u0131l\u0131r.  group ve foreach komutlar\u0131yla kolayca gruplama ve toplama i\u015flemlerini yapabiliyoruz.  Sonu\u00e7lar ayr\u0131ca daha kolay bir \u015fekilde kaydedilebiliyor.  Bu, SQL&#8217;deki karma\u015f\u0131k sorgulardan daha verimli bir \u00e7\u00f6z\u00fcmd\u00fcr.<\/p>\n<h2>Sonu\u00e7<\/h2>\n<p>Hem SQL hem de SPL ile grup i\u00e7i hesaplamalar ve ilk kayda yazma i\u015flemi yap\u0131labilir. Ancak, SPL, bu t\u00fcr i\u015flemler i\u00e7in daha sade, verimli ve okunakl\u0131 bir yakla\u015f\u0131m sunar.  \u00d6zellikle b\u00fcy\u00fck veri setlerinde SPL&#8217;nin performans avantaj\u0131 daha belirgin hale gelir.  Bu nedenle, verimli veri i\u015fleme aray\u0131\u015f\u0131nda olanlar i\u00e7in SPL&#8217;yi de\u011ferlendirmenizi \u00f6neririm. Daha fazla bilgi i\u00e7in <a href=\"https:\/\/fatihsoysal.com\">fatihsoysal.com<\/a> sitesini ziyaret edebilirsiniz.<\/p>\n<p>Ayr\u0131ca, konuyla ilgili daha fazla kaynak i\u00e7in \u015fu ba\u011flant\u0131lar\u0131 inceleyebilirsiniz: <a href=\"https:\/\/dev.to\/judith677\/calculate-based-on-the-records-within-the-group-and-fill-the-result-into-the-first-record-from-22p2\">\u00d6zg\u00fcn Makale<\/a> <\/p>\n<h3>#Etiketler<\/h3>\n<p>#SQL #SPL #Veri\u0130\u015fleme #Gruplama #Hesaplama #Veritaban\u0131 #Programlama #Kod\u00d6rne\u011fi #\u0130lkKay\u0131t<\/p>\n<p><\/body><br \/>\n<\/html><\/p>\n","protected":false},"excerpt":{"rendered":"SQL&#8217;den SPL&#8217;ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma Veri i\u015flemede s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir durum, bir veritaban\u0131ndaki kay\u0131tlar\u0131&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-14737","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL&#039;den SPL&#039;ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma<\/title>\n<meta name=\"description\" content=\"Veri i\u015flemede s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir durum, bir veritaban\u0131ndaki kay\u0131tlar\u0131 grupland\u0131rarak bu gruplar \u00fczerinde hesaplamalar yapma ve sonucu ilk kayda yazma ihtiyac\u0131d\u0131r. Bu makalede, SQL&#039;den SPL&#039;ye ge\u00e7i\u015fi ele alarak, bu i\u015flemin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131z. \u00d6ncelikle SQL&#039;de nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6rece\u011fiz, ard\u0131ndan SPL&#039;deki e\u015fde\u011ferini inceleyip kar\u015f\u0131la\u015ft\u0131raca\u011f\u0131z. Sonras\u0131nda ise, pratik \u00f6rneklerle konuyu daha iyi kavrayaca\u011f\u0131z.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL&#039;den SPL&#039;ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma\" \/>\n<meta property=\"og:description\" content=\"Veri i\u015flemede s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir durum, bir veritaban\u0131ndaki kay\u0131tlar\u0131 grupland\u0131rarak bu gruplar \u00fczerinde hesaplamalar yapma ve sonucu ilk kayda yazma ihtiyac\u0131d\u0131r. Bu makalede, SQL&#039;den SPL&#039;ye ge\u00e7i\u015fi ele alarak, bu i\u015flemin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131z. \u00d6ncelikle SQL&#039;de nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6rece\u011fiz, ard\u0131ndan SPL&#039;deki e\u015fde\u011ferini inceleyip kar\u015f\u0131la\u015ft\u0131raca\u011f\u0131z. Sonras\u0131nda ise, pratik \u00f6rneklerle konuyu daha iyi kavrayaca\u011f\u0131z.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-10T03:00:14+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"SQL&#8217;den SPL&#8217;ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma\",\"datePublished\":\"2025-03-10T03:00:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/\"},\"wordCount\":452,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/\",\"name\":\"SQL'den SPL'ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-03-10T03:00:14+00:00\",\"description\":\"Veri i\u015flemede s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir durum, bir veritaban\u0131ndaki kay\u0131tlar\u0131 grupland\u0131rarak bu gruplar \u00fczerinde hesaplamalar yapma ve sonucu ilk kayda yazma ihtiyac\u0131d\u0131r. Bu makalede, SQL'den SPL'ye ge\u00e7i\u015fi ele alarak, bu i\u015flemin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131z. \u00d6ncelikle SQL'de nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6rece\u011fiz, ard\u0131ndan SPL'deki e\u015fde\u011ferini inceleyip kar\u015f\u0131la\u015ft\u0131raca\u011f\u0131z. Sonras\u0131nda ise, pratik \u00f6rneklerle konuyu daha iyi kavrayaca\u011f\u0131z.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL&#8217;den SPL&#8217;ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL'den SPL'ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma","description":"Veri i\u015flemede s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir durum, bir veritaban\u0131ndaki kay\u0131tlar\u0131 grupland\u0131rarak bu gruplar \u00fczerinde hesaplamalar yapma ve sonucu ilk kayda yazma ihtiyac\u0131d\u0131r. Bu makalede, SQL'den SPL'ye ge\u00e7i\u015fi ele alarak, bu i\u015flemin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131z. \u00d6ncelikle SQL'de nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6rece\u011fiz, ard\u0131ndan SPL'deki e\u015fde\u011ferini inceleyip kar\u015f\u0131la\u015ft\u0131raca\u011f\u0131z. Sonras\u0131nda ise, pratik \u00f6rneklerle konuyu daha iyi kavrayaca\u011f\u0131z.","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:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/","og_locale":"tr_TR","og_type":"article","og_title":"SQL'den SPL'ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma","og_description":"Veri i\u015flemede s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir durum, bir veritaban\u0131ndaki kay\u0131tlar\u0131 grupland\u0131rarak bu gruplar \u00fczerinde hesaplamalar yapma ve sonucu ilk kayda yazma ihtiyac\u0131d\u0131r. Bu makalede, SQL'den SPL'ye ge\u00e7i\u015fi ele alarak, bu i\u015flemin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131z. \u00d6ncelikle SQL'de nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6rece\u011fiz, ard\u0131ndan SPL'deki e\u015fde\u011ferini inceleyip kar\u015f\u0131la\u015ft\u0131raca\u011f\u0131z. Sonras\u0131nda ise, pratik \u00f6rneklerle konuyu daha iyi kavrayaca\u011f\u0131z.","og_url":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-03-10T03:00:14+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"SQL&#8217;den SPL&#8217;ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma","datePublished":"2025-03-10T03:00:14+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/"},"wordCount":452,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/","url":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/","name":"SQL'den SPL'ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-03-10T03:00:14+00:00","description":"Veri i\u015flemede s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir durum, bir veritaban\u0131ndaki kay\u0131tlar\u0131 grupland\u0131rarak bu gruplar \u00fczerinde hesaplamalar yapma ve sonucu ilk kayda yazma ihtiyac\u0131d\u0131r. Bu makalede, SQL'den SPL'ye ge\u00e7i\u015fi ele alarak, bu i\u015flemin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini ad\u0131m ad\u0131m a\u00e7\u0131klayaca\u011f\u0131z. \u00d6ncelikle SQL'de nas\u0131l yap\u0131laca\u011f\u0131n\u0131 g\u00f6rece\u011fiz, ard\u0131ndan SPL'deki e\u015fde\u011ferini inceleyip kar\u015f\u0131la\u015ft\u0131raca\u011f\u0131z. Sonras\u0131nda ise, pratik \u00f6rneklerle konuyu daha iyi kavrayaca\u011f\u0131z.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-ici-hesaplamalar-ve-ilk-kayita-yazma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL&#8217;den SPL&#8217;ye: Grup \u0130\u00e7i Hesaplamalar ve \u0130lk Kay\u0131ta Yazma"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/14737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=14737"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/14737\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=14737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=14737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=14737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}