SQL ORDER BY Ascending

The SQL ORDER BY ASC is used to sort records in the result set in ascending order. This is the default behavior of most of the databases. That means if you miss the ASC keyword after the ORDER BY clause, the database by default sorts the data in ascending order.

Syntax

SELECT expressions 
FROM tables 
[WHERE conditions] 
ORDER BY expression ASC;

Here,

• expressions – expressions defined here the column(s) or calculation you want to retrieve. If you want to retrieve all the columns simply use * in the place of expressions.
• tables – one or more than one table from where you want to retrieve data.
• WHERE conditions – Optional. This is used to specify some conditions while selecting data. In case you are not using the WHERE clause, all the rows available will be selected.
• ORDER BY – This argument is used to sort the result set. If you want to sort on more than one column, you need to provide them in comma-separated.
• ASC – ASC sort the result set in ascending order. This is the default behavior if no modifier is mentioned.

Example

Consider an Employee table with the following data.

The below statement sorts the result in ascending order by NAME and SALARY.

SELECT * FROM Employee
ORDER BY NAME, SALARY;

This produces the following result: