Difference between revisions of "ORDER BY Clause"
Jump to navigation
Jump to search
(Created page with " *When sorting in ascending order, values are listed in this order: 1. Blank and special characters 2. Numeric values 3. Character values (uppercase first) 4. NULL values * Un...") |
(No difference)
|
Revision as of 20:01, 24 October 2017
- When sorting in ascending order, values are listed in this order:
1. Blank and special characters 2. Numeric values 3. Character values (uppercase first) 4. NULL values
- Unless you specify “DESC” for descending, the ORDER BY clause sorts in ascending order by default.
SELECT * FROM publisher ORDER BY name DESC