Skip to main content

Posts

Showing posts with the label SQL ORDER BY ASC DESC Clause

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