In this article, we will learn how to display SQL data in descending order using the ORDER BY keyword.
To sort the result-set in ascending or descending order in SQL, The ORDER BY keyword is used.
By default, the ORDER BY keyword sorts the records in ascending order. Use the DESC keyword, To sort the records in descending order.
SELECT column1, column2, ...columnN FROM TABLE_NAME ORDER BY column1, column2, ... ASC|DESC;
The subsequent statement would return all articles from the “Article” table, sorted descending by the “Title” column.
SELECT * FROM Article ORDER BY Title DESC;
The subsequent statement would return all articles from the “Article” table, sorted descending by the “ID” and ascending by the “Title” column. This means that it orders by Id, but if some rows have the same Id, it orders them by Title.
SELECT * FROM Article ORDER BY Id DESC, Title ASC;
Also, check How To Display SQL Data In Ascending Order