Select * from emp order by ((Select max(salary ) from emp)

how to get the salary in descending order with out using
the keyword desc in sql

Question Posted / sanjay

Answer Posted / sanjay

Select * from emp order by ((Select max(salary ) from emp) -
salary)+1

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain in brief about Microsoft SQL server?

1088

How can I create a new template for import ? : sql server management studio

1067

What are the export options of ssrs?

173

What does ss stand for sexually?

1077

Why do we need normalization?

920

What is tablesample?

1105

What is abstracting periodical?

939

How to provide default values to stored procedure parameters?

1062

What is fill factor and pad index?

1007

What is the use of builtinadministrators group in sql server? : sql server security

1041

What is the server name for sql management studio?

1014

Explain sql delete command?

1044

What are the restrictions while creating batches in sql server?

1059

How exceptions can be handled in sql server programming?

1009

How do users use Report Builder with SQL Server data sources?

154