{"id":10112,"date":"2024-04-06T18:09:07","date_gmt":"2024-04-06T15:09:07","guid":{"rendered":"https:\/\/sunucun.com.tr\/bilgi\/?post_type=dt_articles&#038;p=10112"},"modified":"2026-02-06T21:49:01","modified_gmt":"2026-02-06T18:49:01","slug":"mysqlde-verileri-siralama-order-by-kullanimi","status":"publish","type":"post","link":"https:\/\/sunucun.com.tr\/blog\/mysqlde-verileri-siralama-order-by-kullanimi\/","title":{"rendered":"MySQL&#8217;de Verileri S\u0131ralama: ORDER BY Kullan\u0131m\u0131"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucun.com.tr\/blog\/mysqlde-verileri-siralama-order-by-kullanimi\/#ORDER_BY_Ifadesinin_Kullanimi\" >ORDER BY \u0130fadesinin Kullan\u0131m\u0131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucun.com.tr\/blog\/mysqlde-verileri-siralama-order-by-kullanimi\/#ORDER_BY_Ifadesi_ile_Verilerin_Siralanmasi\" >ORDER BY \u0130fadesi ile Verilerin S\u0131ralanmas\u0131<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucun.com.tr\/blog\/mysqlde-verileri-siralama-order-by-kullanimi\/#Sonuc\" >Sonu\u00e7<\/a><\/li><\/ul><\/nav><\/div>\n\r\n<p class=\"wp-block-paragraph\"><strong>Giri\u015f<\/strong><\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL, b\u00fcy\u00fck veri k\u00fcmelerinin sakland\u0131\u011f\u0131 ve i\u015flendi\u011fi yayg\u0131n bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir. Verilerin d\u00fczenli ve eri\u015filebilir bir \u015fekilde sunulmas\u0131, veri analizi ve raporlama s\u00fcre\u00e7lerinde b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. Bu ba\u011flamda, MySQL&#8217;de verileri s\u0131ralamak i\u00e7in kullan\u0131lan &#8220;ORDER BY&#8221; ifadesi, veritaban\u0131 sorgular\u0131nda \u00f6nemli bir rol oynar. &#8220;ORDER BY&#8221;, veritaban\u0131nda saklanan verileri belirli bir s\u00fctuna g\u00f6re s\u0131ralayarak, istenen bilgilerin d\u00fczenli bir \u015fekilde sunulmas\u0131n\u0131 sa\u011flar. Bu makalede, MySQL&#8217;de &#8220;ORDER BY&#8221; ifadesini kullanarak verileri nas\u0131l s\u0131ralayaca\u011f\u0131m\u0131z\u0131, \u00e7e\u015fitli \u00f6rneklerle detayl\u0131 olarak ele alaca\u011f\u0131z.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ORDER_BY_Ifadesinin_Kullanimi\"><\/span>ORDER BY \u0130fadesinin Kullan\u0131m\u0131<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL&#8217;de &#8220;ORDER BY&#8221; ifadesi, verileri belirli bir s\u00fctuna g\u00f6re s\u0131ralamak i\u00e7in kullan\u0131l\u0131r. Bu ifade, s\u0131ralama i\u015flemini artan (ASC) veya azalan (DESC) s\u0131raya g\u00f6re yapabilir. Temel kullan\u0131m\u0131 \u015fu \u015fekildedir:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun1, s\u00fctun2, ... \r\nFROM tablo_ad\u0131 \r\nORDER BY s\u00fctun ASC\/DESC;\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu sorguda:<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>SELECT<\/strong>: Se\u00e7mek istedi\u011finiz s\u00fctunlar\u0131 belirtir.<\/li>\r\n\r\n\r\n\r\n<li><strong>FROM<\/strong>: Verilerin \u00e7ekilece\u011fi tabloyu belirtir.<\/li>\r\n\r\n\r\n\r\n<li><strong>ORDER BY<\/strong>: S\u0131ralama i\u015fleminin yap\u0131laca\u011f\u0131 s\u00fctunu belirtir.<\/li>\r\n\r\n\r\n\r\n<li><strong>ASC<\/strong>: Verileri artan s\u0131rayla s\u0131ralar (varsay\u0131lan olarak).<\/li>\r\n\r\n\r\n\r\n<li><strong>DESC<\/strong>: Verileri azalan s\u0131rayla s\u0131ralar.<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">&#8220;ORDER BY&#8221; ifadesi, \u00f6zellikle b\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken \u00e7ok kullan\u0131\u015fl\u0131d\u0131r. Verilerin anlaml\u0131 bir s\u0131raya g\u00f6re d\u00fczenlenmesi, hem veri analizi hem de raporlama s\u00fcre\u00e7lerinde i\u015flerinizi kolayla\u015ft\u0131r\u0131r.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"530\" src=\"https:\/\/www.sunucun.com.tr\/blog\/\/wp-content\/uploads\/2024\/04\/1024px-MySQL.ff87215b43fd7292af172e2a5d9b844217262571-1.png\" alt=\"MySQL S\u0131ralama\" class=\"wp-image-10113\" style=\"width:587px;height:auto\" srcset=\"https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/1024px-MySQL.ff87215b43fd7292af172e2a5d9b844217262571-1.png 1024w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/1024px-MySQL.ff87215b43fd7292af172e2a5d9b844217262571-1-300x155.png 300w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/1024px-MySQL.ff87215b43fd7292af172e2a5d9b844217262571-1-768x398.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ORDER_BY_Ifadesi_ile_Verilerin_Siralanmasi\"><\/span>ORDER BY \u0130fadesi ile Verilerin S\u0131ralanmas\u0131<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\"><strong>1. Artan veya Azalan S\u0131ralama<\/strong><\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Verilerin artan veya azalan s\u0131raya g\u00f6re s\u0131ralanmas\u0131, en s\u0131k kullan\u0131lan &#8220;ORDER BY&#8221; i\u015flemlerindendir. \u00d6rne\u011fin, m\u00fc\u015fterileri isimlerine g\u00f6re alfabetik olarak s\u0131ralamak isterseniz:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT * FROM m\u00fc\u015fteriler \r\nORDER BY isim ASC;\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu sorgu, &#8220;m\u00fc\u015fteriler&#8221; tablosundaki verileri, isimlerine g\u00f6re alfabetik olarak artan s\u0131rayla s\u0131ralar. E\u011fer verileri tersine s\u0131ralamak isterseniz, ASC yerine DESC kullanabilirsiniz:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT * FROM m\u00fc\u015fteriler \r\nORDER BY isim DESC;\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu \u015fekilde, m\u00fc\u015fteriler isimlerine g\u00f6re azalan s\u0131rayla, yani Z&#8217;den A&#8217;ya do\u011fru s\u0131ralanm\u0131\u015f olarak d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\"><strong>2. Say\u0131sal Verilerin S\u0131ralanmas\u0131<\/strong><\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Say\u0131sal verilerin s\u0131ralanmas\u0131 da olduk\u00e7a yayg\u0131nd\u0131r. \u00d6rne\u011fin, sipari\u015fleri tutarlar\u0131na g\u00f6re b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe s\u0131ralamak i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabilirsiniz:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT * FROM sipari\u015fler \r\nORDER BY tutar DESC;\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu sorgu, &#8220;sipari\u015fler&#8221; tablosundaki verileri, tutarlar\u0131na g\u00f6re b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe s\u0131ralar. Say\u0131sal verilerin bu \u015fekilde s\u0131ralanmas\u0131, \u00f6zellikle finansal raporlamalarda ve sat\u0131\u015f analizlerinde olduk\u00e7a yararl\u0131d\u0131r.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\"><strong>3. Birden Fazla S\u00fctuna G\u00f6re S\u0131ralama<\/strong><\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bazen verilerin daha karma\u015f\u0131k bir \u015fekilde s\u0131ralanmas\u0131 gerekebilir. \u00d6rne\u011fin, bir \u00fcr\u00fcnler tablosunda \u00f6nce kategoriye g\u00f6re, ard\u0131ndan her kategoride fiyat\u0131na g\u00f6re s\u0131ralama yapmak i\u00e7in a\u015fa\u011f\u0131daki sorgu kullan\u0131labilir:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT * FROM \u00fcr\u00fcnler \r\nORDER BY kategori ASC, fiyat DESC;\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu sorgu, \u00fcr\u00fcnleri \u00f6nce kategoriye g\u00f6re alfabetik olarak s\u0131ralar, ard\u0131ndan her kategori i\u00e7erisindeki \u00fcr\u00fcnleri fiyatlar\u0131na g\u00f6re b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe s\u0131ralar. Bu t\u00fcr \u00e7ok seviyeli s\u0131ralama i\u015flemleri, \u00f6zellikle karma\u015f\u0131k veri k\u00fcmelerinde anlaml\u0131 s\u0131ralamalar yapmak i\u00e7in idealdir.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\"><strong>4. S\u0131n\u0131rl\u0131 Say\u0131da Sonu\u00e7 D\u00f6nd\u00fcrme (LIMIT)<\/strong><\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Verileri s\u0131ralad\u0131ktan sonra, genellikle en \u00fcstteki belirli say\u0131da sat\u0131r\u0131 almak isteyebilirsiniz. Bu durumda, &#8220;ORDER BY&#8221; ifadesini &#8220;LIMIT&#8221; anahtar\u0131 ile birlikte kullanabilirsiniz. \u00d6rne\u011fin, en pahal\u0131 10 \u00fcr\u00fcn\u00fc listelemek i\u00e7in:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT * FROM \u00fcr\u00fcnler \r\nORDER BY fiyat DESC \r\nLIMIT 10;\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu sorgu, \u00fcr\u00fcnleri fiyatlar\u0131na g\u00f6re b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe s\u0131ralar ve en pahal\u0131 10 \u00fcr\u00fcn\u00fc d\u00f6nd\u00fcr\u00fcr. Bu y\u00f6ntem, \u00f6zellikle sat\u0131\u015f raporlamalar\u0131 ve en iyi performans g\u00f6steren \u00fcr\u00fcnlerin listelenmesi gibi durumlarda olduk\u00e7a kullan\u0131\u015fl\u0131d\u0131r.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc\"><\/span>Sonu\u00e7<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu makalede, MySQL&#8217;de <a href=\"https:\/\/www.sunucun.com.tr\/blog\/dt-articles\/mysqlde-verileri-siralama-order-by-kullanimi\/\">&#8220;ORDER BY&#8221;<\/a> ifadesini kullanarak verileri s\u0131ralaman\u0131n \u00e7e\u015fitli yollar\u0131n\u0131 inceledik. Veritaban\u0131 y\u00f6netiminde, verilerin anlaml\u0131 ve d\u00fczenli bir \u015fekilde sunulmas\u0131 b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. &#8220;ORDER BY&#8221; ifadesi, verilerinizi ihtiya\u00e7lar\u0131n\u0131za uygun bir s\u0131rayla d\u00fczenlemenizi sa\u011flayarak, veri analizi ve raporlama s\u00fcre\u00e7lerinizi daha verimli hale getirir.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Veritaban\u0131 sorgular\u0131n\u0131zda &#8220;ORDER BY&#8221; ifadesini etkin bir \u015fekilde kullanarak, verilerinizin daha d\u00fczenli ve analiz edilebilir hale gelmesini sa\u011flayabilirsiniz. Bu da, i\u015f s\u00fcre\u00e7lerinizde daha h\u0131zl\u0131 ve do\u011fru kararlar alman\u0131za yard\u0131mc\u0131 olur.<\/p>\r\n\r\n","protected":false},"excerpt":{"rendered":"<p>Giri\u015f MySQL, b\u00fcy\u00fck veri k\u00fcmelerinin sakland\u0131\u011f\u0131 ve i\u015flendi\u011fi yayg\u0131n bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir. Verilerin d\u00fczenli ve eri\u015filebilir bir \u015fekilde sunulmas\u0131, veri analizi ve raporlama s\u00fcre\u00e7lerinde b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. Bu ba\u011flamda, MySQL&#8217;de verileri s\u0131ralamak i\u00e7in kullan\u0131lan &#8220;ORDER BY&#8221; ifadesi, veritaban\u0131 sorgular\u0131nda \u00f6nemli bir rol oynar. &#8220;ORDER BY&#8221;, veritaban\u0131nda saklanan verileri belirli bir s\u00fctuna g\u00f6re s\u0131ralayarak,&hellip;<\/p>\n","protected":false},"author":1,"featured_media":10084,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1525,1521],"tags":[],"class_list":["post-10112","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-siber-guvenlik","category-teknoloji"],"_links":{"self":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=10112"}],"version-history":[{"count":1,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10112\/revisions"}],"predecessor-version":[{"id":16487,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10112\/revisions\/16487"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media\/10084"}],"wp:attachment":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=10112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=10112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=10112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}