{"id":599,"date":"2024-09-02T06:55:24","date_gmt":"2024-09-02T06:55:24","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=599"},"modified":"2025-06-03T13:00:07","modified_gmt":"2025-06-03T13:00:07","slug":"order-by","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/order-by\/","title":{"rendered":"ORDER BY"},"content":{"rendered":"\n

SQL ORDER BY Keyword<\/h2>\n\n\n\n

The ORDER BY clause is used to sort the results of a query in ascending<\/strong> (default) or descending<\/strong> order.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL ORDER BY Syntax<\/h2>\n\n\n\n
SELECT column1, column2, ...\nFROM table_name\nORDER BY column1 [ASC | DESC], column2 [ASC | DESC], ...;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL ORDER BY Default (Ascending) Example<\/h2>\n\n\n\n
This query selects all patients and sorts them by last_name in ascending order.<\/p>\n\n\n\n
SELECT *\nFROM Patients\nORDER BY last_name;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL ORDER BY ASC Example<\/h2>\n\n\n\n
This query selects all doctors and sorts them by specialty in ascending (A\u2013Z) order.<\/p>\n\n\n\n
SELECT *\nFROM Doctors\nORDER BY specialty ASC;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL ORDER BY DESC Example<\/h2>\n\n\n\n
This query selects all appointments and sorts them by appointment_date in descending (latest first) order.<\/p>\n\n\n\n
SELECT *\nFROM Appointments\nORDER BY appointment_date DESC;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL ORDER BY Labs<\/h2>\n\n\n\n