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" column:

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 data to …

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.

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 value …

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.

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 columns to ORDER BY. SQL sorts by the first …

Learn how to use the SQL ORDER BY clause to sort your query results in ascending or descending order, making data retrieval more efficient and meaningful.

ASC is used in ORDER BY clauses to indicate that the results should be sorted in ascending order. However it is a redundant modifier as ascending order is the default for SQL.

Sep 15, 2025 · Master the SQL ORDER BY to sort query results in ascending or descending order on single or multiple columns. The example includes usage with LIMIT and WHERE clauses.