adspace


How to sort query output in descending order in ms sql server?

Answer Posted / Abhijeet Dubey

Add the ORDER BY clause with the DESC keyword at the end of your SELECT statement. For example: SELECT column_name FROM table_name ORDER BY column_name DESC;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is standby servers? Explain types of standby servers.

1090


What are the properties of the transaction?

1086


What is subquery? Explain the properties of a subquery?

1070


What is an indexed view?

1030


Explain “row_number()” in sql server with an example?

1087


What is in place upgrade in sql server?

1137


What is the primary use of the model database?

1157


Where can you add custom error messages to sql server?

1223


What is a scheduled job or what is a scheduled task?

1044


What is temporary table in sql server? Why we use temp table?

1028


How to convert numeric expression data types using the cast() function?

1157


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1210


How to remove duplicate rows from table except one?

1096


When should you use an instead of trigger?

1062


How can we solve concurrency problems?

1130