SQL ORDER BY ASC/DESC Clause

The “ORDER BY” Clause is use to ensure a specific order and returns records that is no particular order. It’s allows sorting by signal or multiples columns.

The Returned records can be “ascending” or “descending” order and the default order is ascending.

Stayed Informed - 37 Best SQL Server Interview Questions and Answers

Syntax:-

SELECT DISTINCT CountryName FROM Countries
ORDER BY CountryName DESC

Examples:-

SELECT DISTINCT CountryName, CountryCode
 FROM Countries
ORDER BY CountryName DESC

Result:-

CountryName CountryCode
----------------------------
USA           US
Rasia           RA
Nepal           NP
India           IN

Stayed Informed - SQL Server Query and Examples

I hope you are enjoying with this post! Please share with you friends. Thank you!!

Pin it

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2