{"id":7606,"date":"2024-03-14T06:45:54","date_gmt":"2024-03-14T06:45:54","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/"},"modified":"2025-08-02T18:25:59","modified_gmt":"2025-08-02T18:25:59","slug":"how-to-use-mysql-statements-for-ascending-and-descending-order","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/","title":{"rendered":"MySQL ORDER BY: ASC &#038; DESC Sorting Guide"},"content":{"rendered":"<p>In MySQL, you can use the ORDER BY clause to sort query results in ascending or descending order. Here is an example statement:<\/p>\n<ol>\n<li>Sort by<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> column1, column2\r\n<span class=\"hljs-keyword\">FROM<\/span> table_name\r\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> column1 <span class=\"hljs-keyword\">ASC<\/span>;\r\n<\/code><\/pre>\n<p>In the example above, ORDER BY column1 ASC indicates sorting in ascending order by the values in column1.<\/p>\n<ol>\n<li>sort by<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> column1, column2\r\n<span class=\"hljs-keyword\">FROM<\/span> table_name\r\n<span class=\"hljs-keyword\">ORDER<\/span> <span class=\"hljs-keyword\">BY<\/span> column1 <span class=\"hljs-keyword\">DESC<\/span>;\r\n<\/code><\/pre>\n<p>In the example above, ORDER BY column1 DESC indicates a descending order based on the values in column1.<\/p>\n<p>It is important to note that if no sorting method is specified, the default is to sort in ascending order. You can choose between ascending or descending order based on your specific needs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MySQL, you can use the ORDER BY clause to sort query results in ascending or descending order. Here is an example statement: Sort by SELECT column1, column2 FROM table_name ORDER BY column1 ASC; In the example above, ORDER BY column1 ASC indicates sorting in ascending order by the values in column1. sort by SELECT [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[9803,284,298,3793,5708],"class_list":["post-7606","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-asc-desc","tag-database","tag-mysql","tag-order-by","tag-sql-sorting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL ORDER BY: ASC &amp; DESC Sorting Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to use MySQL ORDER BY clause to sort data in ascending (ASC) and descending (DESC) order with practical examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL ORDER BY: ASC &amp; DESC Sorting Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to use MySQL ORDER BY clause to sort data in ascending (ASC) and descending (DESC) order with practical examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T06:45:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T18:25:59+00:00\" \/>\n<meta name=\"author\" content=\"Liam\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liam\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/\"},\"author\":{\"name\":\"Liam\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\"},\"headline\":\"MySQL ORDER BY: ASC &#038; DESC Sorting Guide\",\"datePublished\":\"2024-03-14T06:45:54+00:00\",\"dateModified\":\"2025-08-02T18:25:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/\"},\"wordCount\":103,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"ASC DESC\",\"database\",\"MySQL\",\"ORDER BY\",\"SQL sorting\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/\",\"name\":\"MySQL ORDER BY: ASC & DESC Sorting Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T06:45:54+00:00\",\"dateModified\":\"2025-08-02T18:25:59+00:00\",\"description\":\"Learn how to use MySQL ORDER BY clause to sort data in ascending (ASC) and descending (DESC) order with practical examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL ORDER BY: ASC &#038; DESC Sorting Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671\",\"name\":\"Liam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g\",\"caption\":\"Liam\"},\"sameAs\":[\"http:\/\/Wilson\"],\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL ORDER BY: ASC & DESC Sorting Guide - Blog - Silicon Cloud","description":"Learn how to use MySQL ORDER BY clause to sort data in ascending (ASC) and descending (DESC) order with practical examples.","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:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/","og_locale":"en_US","og_type":"article","og_title":"MySQL ORDER BY: ASC & DESC Sorting Guide","og_description":"Learn how to use MySQL ORDER BY clause to sort data in ascending (ASC) and descending (DESC) order with practical examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T06:45:54+00:00","article_modified_time":"2025-08-02T18:25:59+00:00","author":"Liam","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Liam","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/"},"author":{"name":"Liam","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671"},"headline":"MySQL ORDER BY: ASC &#038; DESC Sorting Guide","datePublished":"2024-03-14T06:45:54+00:00","dateModified":"2025-08-02T18:25:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/"},"wordCount":103,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["ASC DESC","database","MySQL","ORDER BY","SQL sorting"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/","name":"MySQL ORDER BY: ASC & DESC Sorting Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T06:45:54+00:00","dateModified":"2025-08-02T18:25:59+00:00","description":"Learn how to use MySQL ORDER BY clause to sort data in ascending (ASC) and descending (DESC) order with practical examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-use-mysql-statements-for-ascending-and-descending-order\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL ORDER BY: ASC &#038; DESC Sorting Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/23786905eb7b377f45ddb01c17da7671","name":"Liam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d37ed3e7f770dde8bf069ba0b4298688028c3abaacf1131742fc1352d174ebd?s=96&d=mm&r=g","caption":"Liam"},"sameAs":["http:\/\/Wilson"],"url":"https:\/\/www.silicloud.com\/blog\/author\/liamwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=7606"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7606\/revisions"}],"predecessor-version":[{"id":152392,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7606\/revisions\/152392"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=7606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=7606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=7606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}