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

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1034

How do you delete duplicate rows in sql server?

901

What is the difference function and stored procedure?

995

Explain what is it unwise to create wide clustered index keys?

932

What is a covering index?

921

How to move database physical files in ms sql server?

961

What is difference between count (*) and count 1?

867

What is named query? : sql server analysis services, ssas

909

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

846

How to use go command in "sqlcmd"?

1130

What do you mean by cardinality?

848

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2448

Is port 1433 secure?

931

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5873

What is normalization process?

1109