15 Best SQL Queries for Developers [SQL Queries]

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.

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!!
ANIL SINGH

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 Blogs - https://code-sample.com and https://code-sample.xyz
My Book1 - BEST SELLING ANGULAR BOOK (INCLUDING ALL VERSIONS 2, 4, 5, 6, 7)
My Book2 - ANGULAR 2 INTERVIEW QUESTIONS BOOK - Both Books are Available on WorldWide.

www.code-sample.com/. Powered by Blogger.