The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

We can use the ASC keyword to explicitly sort selected records in ascending order. For example, FROM Customers. ORDER BY age ASC; Here, the SQL command selects all the rows from Customers table and then sorts them in ascending order by age. Note: The ORDER BY clause sorts result set in ascending by default, even without the ASC clause.

Dec 20, 2021 · SQL ORDER BY Clause Basics. The ORDER BY clause of a SQL SELECT statement goes at the end. 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 expressions are usually columns, but they do not have to be columns.

In this tutorial, we will guide you through the syntax of SQL ORDER BY clause, and how to use it in SQL statements with the help of examples. The basic syntax of the SQL ORDER BY clause is as follows: SELECT column1, column2, ... FROM table_name. ORDER BY column1 [ASC | DESC], column2 [ASC | DESC], ...;

ORDER BY clause in SQL enables us to sort results of the query by specific field (column) or more columns. There are 2 sorting options: Ascending order (ASC) – sorts records from lowest to highest in case of numbers and from A to Z in case of text strings

Nov 12, 2019 · Order By is a SQL command that lets you sort the resulting output from a SQL query. Order By (ASC, DESC) ORDER BY gives us a way to SORT the result set by one or more of the items in the SELECT section.

This SQL tutorial explains how to use the SQL ORDER BY clause with syntax and examples. 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 retrieve. The tables that you wish to retrieve records from.

Feb 18, 2025 · By using the ORDER BY clause, you can arrange results based on specified columns, making it easier to glean insights from your data. The syntax of the ORDER BY clause is straightforward: SELECT column1, column2, ... FROM table_name ORDER BY column1 [ASC|DESC], column2 [ASC|DESC], ...; In this syntax: ASC stands for ascending order (default).

SQL Editor. The ORDER BY clause returns a result set in a specified sort order. Rows can be returned in ascending (ASC) or descending (DESC) order.

Order by Clause is an optional expression in an sql query. If we don’t write, the query sorts according to the primary key column. Orderby clause is used to sort table according to the specified column or the columns. For ascending sort, we write “asc” or nothing after column name. For Descending sort, we write “desc” after column name.