Loading lesson path
Concept visual
Start at both ends
❮ SQL Keywords
command is used to sort the result set in ascending or descending order.
command sorts the result set in ascending order by default. To sort the records in descending order, use the DESC keyword. The following SQL statement selects all the columns from the "Customers" table, sorted by the "CustomerName" column:
SELECT * FROM Customers
ORDER BY CustomerName;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;command is used to sort the data returned in descending order. The following SQL statement selects all the columns from the "Customers" table, sorted descending by the "CustomerName" column:
SELECT * FROM Customers
ORDER BY CustomerName DESC;❮ SQL Keywords