{"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'den SPL'ye: Grup \u0130\u00e7inde En Yak\u0131n E\u015fle\u015fmeyi Bulma","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"rAY5eTTmd3\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-icinde-en-yakin-eslesmeyi-bulma\/\">SQL&#8217;den SPL&#8217;ye: Grup \u0130\u00e7inde En Yak\u0131n E\u015fle\u015fmeyi Bulma<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sqlden-splye-grup-icinde-en-yakin-eslesmeyi-bulma\/embed\/#?secret=rAY5eTTmd3\" width=\"600\" height=\"338\" title=\"&#8220;SQL&#8217;den SPL&#8217;ye: Grup \u0130\u00e7inde En Yak\u0131n E\u015fle\u015fmeyi Bulma&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"rAY5eTTmd3\" 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":"Merhaba, ben Fatih Soysal. Bu yaz\u0131da, veritaban\u0131 sorgulamalar\u0131nda s\u0131kl\u0131kla kar\u015f\u0131la\u015ft\u0131\u011f\u0131m\u0131z bir problemi, yani bir grup i\u00e7inde en yak\u0131n e\u015fle\u015fen kayd\u0131 bulma i\u015flemini, SQL'den SPL'ye (ESProc SPL) nas\u0131l ta\u015f\u0131yabilece\u011fimizi detayl\u0131 olarak inceleyece\u011fiz. SQL'de rahatl\u0131kla yapabildi\u011fimiz bu i\u015flem, farkl\u0131 veritaban\u0131 dillerinde farkl\u0131 yakla\u015f\u0131mlar gerektirebilir. \u00d6zellikle SPL gibi y\u00fcksek performansl\u0131 bir dilde, verimli bir \u00e7\u00f6z\u00fcm bulmak \u00f6nemlidir. Bu nedenle, hem SQL yakla\u015f\u0131m\u0131n\u0131 hem de SPL \u00e7\u00f6z\u00fcm\u00fcn\u00fc ad\u0131m ad\u0131m ele alarak, aralar\u0131ndaki farklar\u0131 ve avantajlar\u0131 g\u00f6sterece\u011fiz."}