SQL ORDER BY Keyword - W3Schools
To sort the table reverse alphabetically, use the DESC keyword: Sort the products by ProductName in reverse order: The following SQL statement selects all customers from the …
SQL ORDER BY
ASC and DESC stand for ascending and descending respectively. The ORDER BY clause uses the ASC option by default. It means that the ORDER BY clause sorts the rows in the result set …
SQL ORDER BY - GeeksforGeeks
Aug 25, 2025 · The ORDER BY clause in SQL is used to sort query results based on one or more columns in either ascending (ASC) or descending (DESC) order. Whether you are presenting …
ORDER BY clause (Transact-SQL) - SQL Server | Microsoft Learn
Nov 18, 2025 · Specifies that the values in the specified column should be sorted in ascending or descending order. ASC sorts from the lowest value to highest value. DESC sorts from highest …
ORDER BY in MySQL: DESC & ASC Query with EXAMPLE - Guru99
Jul 17, 2024 · The keyword DESC in SQL, is used to sort the query result set in a descending order. The ASC keyword is used to sort the query result set in an ascending order.
SQL: ORDER BY Clause - TechOnTheNet
To sort your results in ascending order, you can specify the ASC attribute. If no value (ASC or DESC) is provided after a field in the ORDER BY clause, the sort order will default to …
SQL ORDER BY Clause (With Examples) - Programiz
The SQL ORDER BY clause is used to sort the selected rows in ascending or descending order. In this tutorial, you will learn about the SQL ORDER BY clause with the help of examples.
Order By – SQL Tutorial
In this syntax, column1, column2, etc. are the columns that you want to sort the result set by, and ASC or DESC specifies the sort order. By default, the ORDER BY clause sorts the result set in …
SQL ORDER BY Clause Code Examples - SQL Server Tips
Dec 20, 2021 · It includes the keywords ORDER BY followed by a series of expressions (ASC | DESC) on which the data should be sorted (Ascending Order or Descending Order). These …
SQL ORDER BY Clause - TutorialsTeacher.com
Use ASC to sort the records in ascending order or use DESC for descending order. By default, the ORDER BY clause sort the records in ascending order if the order is not specified.