SQL ASC Keyword

ASC

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

The following SQL statement selects all the columns from the “Customers” table, sorted by the “CustomerName” column:

SELECT * FROM Customers
ORDER BY CustomerName ASC;