SQL Keyword - ASC

In this article we learn about SQL Keyword - ASC

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

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

Example 1

SELECT * FROM Employee ORDER BY Emp_Name ASC;

Example 2 

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

Summary

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