{"id":141,"date":"2024-08-21T05:17:59","date_gmt":"2024-08-21T05:17:59","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=141"},"modified":"2025-05-09T08:51:25","modified_gmt":"2025-05-09T08:51:25","slug":"sql-order-by","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/sql-order-by\/","title":{"rendered":"SQL Order By"},"content":{"rendered":"\n

The SQL Order By clause is used to sort the result set of a query by on more columns. By default, the results are sorted in ascending order, but you can also sort them in descendinng 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 Example<\/h2>\n\n\n\n
SQL Order By Descending Order Example<\/h3>\n\n\n\n
This query retrieves all columns from the PATIENTS table and sorts the results by the dob (date of birth) coluumn in descending order.<\/p>\n\n\n\n
SELECT * FROM Patients\nORDER BY dob DESC;<\/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 Several Columns Example<\/h3>\n\n\n\n
This query retrieves all columns from the DOCTORS table and sorts the results by the specialty column in ascending order. Within each specialty, it further sorts the results by the last_name column, also in ascending order.<\/p>\n\n\n\n
SELECT * FROM Doctors\nORDER BY specialty ASC, last_name ASC;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Order By Using both Ascending and Descending Order Example<\/h3>\n\n\n\n
This query retrieves all columns from the APPOINTMENTS table and sorts the results by the STATUS column in ascending order. Within eash status category, it further sorts the results by the appointment_date column in descending order.<\/p>\n\n\n\n
SELECT * FROM Appointments\nORDER BY status ASC, appointment_date DESC;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Order By Visual Diagram<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Order By Labs<\/h2>\n\n\n\n