ORDER BY Clause

• 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

Back To Top- Home - Category