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

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book