The following SQL statement selects all customers from the "Customers" table, sorted by the "Country" and the "CustomerName" column. This means that it orders by Country, but if some …

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 …

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

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 …

The ORDER BY clause is used to get the sorted records on one or more columns in ascending or descending order. The ORDER BY clause must come after the WHERE, GROUP BY, and …

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 …

In SQL ORDER BY clause, we need to define ascending or descending order in which result needs to be sorted. By default, SQL Server sorts out results using ORDER BY clause in …

In SQL, the ORDER BY clause allows you to specify different sort directions for different columns within the same query. You can apply ASC (ascending) to one column and DESC …

By default, it arranges the rows in ascending order, but you can explicitly set it to sort descending as well. Whether you're building reports or cleaning data for analysis, ORDER BY in SQL …