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 tablesample?

982

What is oltp (online transaction processing)?

984

How to loop through result set objects using odbc_fetch_row()?

955

What is the New in SQL server 2008?

953

Explain indexes disadvantages?

1067

What are the basic functions for master, msdb, model, tempdb databases?

1027

How to transfer data from a cursor to variables with a "fetch" statement?

1072

Other than truncate statement, which other command can by-pass the trigger on the tables?

1112

When I delete any data from a table, does the sql server reduce the size of that table?

996

What is dbcc command in sql server?

1069

Is it safe to delete log files?

903

How to locate and take substrings with charindex() and substring() functions?

997

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

931

How you can change the database name in SQL SERVER?

1175

Explain a join?

1048