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

Answers were Sorted based on User's Feedback



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

Answer / sanjay

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

Is This Answer Correct ?    12 Yes 0 No

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

Answer / robin thomas

select * from emp order by -sal

Is This Answer Correct ?    4 Yes 0 No

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

Answer / arul

Select Salary from (Select Salary as x from employee) where
x < salary

Is This Answer Correct ?    1 Yes 4 No

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

Answer / gourav

select salary from(select salary,rownum as r from (select salary from employees))
where r<9;

Is This Answer Correct ?    2 Yes 8 No

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

Answer / k.subramanyam

select * from emp order by sal

Is This Answer Correct ?    9 Yes 40 No

Post New Answer

More SQL Server Interview Questions

What are the restraints imposed on the table design by a merge replication?

0 Answers  


How to create user messages with print statements in ms sql server?

0 Answers  


What are character string data types in ms sql server?

0 Answers  


how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  


How can I know what locks are running on which resource?

0 Answers  






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

0 Answers  


Why main is user defined function?

0 Answers  


How do I perform an unattended install of sql server 2000?

0 Answers  


How can we rewrite sub-queries into simple select statements or with joins?

0 Answers  


How to find the version of sql server? : sql server database administration

0 Answers  


How to convert numeric expression data types by assignment operations?

0 Answers  


explain the type of contraints

3 Answers  


Categories