Usage and Examples of SQL ASC Keyword

SQL Keyword Reference

ASC

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

The following SQL statement selects all columns from the 'Customers' table and sorts them by the 'CustomerName' column:

SELECT　*　FROM Customers
ORDER BY CustomerName ASC;

SQL Keyword Reference