{"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":"Son Ki\u015fiyi Otob\u00fcs'e Bindirme: SQL ile \u00c7\u00f6z\u00fcm","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"r6emNWtENn\"><a href=\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/\">Son Ki\u015fiyi Otob\u00fcs&#8217;e Bindirme: SQL ile \u00c7\u00f6z\u00fcm<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/embed\/#?secret=r6emNWtENn\" width=\"600\" height=\"338\" title=\"&#8220;Son Ki\u015fiyi Otob\u00fcs&#8217;e Bindirme: SQL ile \u00c7\u00f6z\u00fcm&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"r6emNWtENn\" 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":"Bir otob\u00fcs d\u00fc\u015f\u00fcn\u00fcn; s\u0131n\u0131rl\u0131 kapasitesi var ve yolcular belirli \u00f6zelliklere sahipler. Her yolcuyu belirli kriterlere g\u00f6re otob\u00fcse yerle\u015ftirmeniz ve en son otob\u00fcse binebilecek ki\u015fiyi bulman\u0131z gerekiyor. Bu, SQL'in g\u00fcc\u00fcn\u00fc kullanarak nas\u0131l \u00e7\u00f6z\u00fclebilece\u011fini ad\u0131m ad\u0131m ele alaca\u011f\u0131m\u0131z bir problem. Bu makalede, SQL sorgular\u0131n\u0131 kullanarak bu sorunu \u00e7\u00f6zmenin farkl\u0131 y\u00f6ntemlerini ve performans kar\u015f\u0131la\u015ft\u0131rmalar\u0131n\u0131 inceleyece\u011fiz. Ayn\u0131 zamanda, SQL'e yeni ba\u015flayanlar i\u00e7in temel kavramlardan, ileri d\u00fczey kullan\u0131c\u0131lar i\u00e7in optimizasyon tekniklerine kadar geni\u015f bir yelpazede bilgi sunaca\u011f\u0131z. Haz\u0131rsan\u0131z, bu heyecan verici yolculu\u011fa ba\u015flayal\u0131m!"}