Flash cards
Review the key moves
What is the main idea behind SQL ORDER BY Keyword?
Lesson checks
Practice each idea before moving on
Short Mimo-style checks built from this lesson's code, terms, and sequence.
Which statement best captures the main point of this lesson?
Complete the missing token from the example code.
___ * FROM CustomersPut the learning moves in the order that makes the concept easiest to apply.
Order By
The ORDER BY command is used to sort the result set in ascending or descending order.
The ORDER BY 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:
Example
SELECT * FROM Customers
ORDER BY CustomerName;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:
Example
SELECT * FROM Customers
ORDER BY CustomerName ASC;Desc
The DESC 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:
Example
SELECT * FROM Customers
ORDER BY CustomerName DESC;