The ASC command is used to sort the data returned in ascending order. The following SQL statement selects all the columns from the "Customers" table, sorted by the "CustomerName" …

This tutorial shows you how to use the SQL ORDER BY clause to sort rows returned by the SELECT clause in ascending or descending order.

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 …

Nov 18, 2025 · Sorts data returned by a query in SQL Server. Use this clause to: Order the result set of a query by the specified column list and, optionally, limit the rows returned to a specified …

In this tutorial, you will learn about the SQL ORDER BY clause with the help of examples.

By default, sorting is ascending. Use DESC to reverse the default (largest/most recent first). If you want the smallest or oldest first, use ascending (or omit DESC). You can pass multiple …

Jul 7, 2025 · Sorting data is one of the most common tasks in SQL, and the ORDER BY clause is the tool to do just that. Whether you want to display results in alphabetical order, highest-to …

Ascending Order (ASC) - Default: 2. Descending Order (DESC): 3. Mixed Sorting Directions: 1. Primary and Secondary Sort: 💡 Order matters! SQL sorts by the first column, then breaks ties …

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. For the …

The SQL ORDER BY clause is used to sort the records in the result set for a SELECT statement. The syntax for the ORDER BY clause in SQL is: The columns or calculations that you wish to …