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.

SQL sorts by the first column, then breaks ties using the second, and so on. In this example results are sorted by Category. Within each category, higher-rated items come first; for equal …

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 …

In summary, the SQL ORDER BY clause is a powerful tool that allows you to sort the result set of a SELECT statement in a specified order. It can be used to sort the result set by one or more …

The SQL ORDER BY clause sorts a query's results in a specific order. It arranges the result set in ascending or descending order using one or more columns. The sorting can be performed on …

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 …