Introduction

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.

Syntax

SELECT column1, column2, ...columnN
FROM TABLE_NAME
ORDER BY column1, column2, ... ASC|DESC;

Example-1

The subsequent statement would return all articles from the “Article” table, sorted descending by the “Title” column.

SELECT * FROM Article
ORDER BY Title DESC;

Example-2

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