ASC Keyword

The ASC keyword or command is used to sort the data in ascending order.

We have specified the column sort order using the ASC keyword.

Syntax

SQL
SELECT * FROM <TABLE_NAME> ORDER BY <COLUMN_NAME> ASC;

Example 1

SQL
SELECT * FROM Employee ORDER BY Emp_Name ASC;

Example 2

SQL
SELECT * FROM Employee ORDER BY Emp_Name ASC,Emp_Salary ASC;

Summary

The ASC Keyword helps us to sort the result in ascending order.