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 is denormalization? : Sql server database administration

0 Answers  


Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  


What is difference between delete & truncate commands?

0 Answers  


Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,






Is sql server free?

0 Answers  


What command is used to rename the database?

0 Answers  


How do I start sql server agent automatically?

0 Answers  


What is the temp table?

0 Answers  


What is difference between unique and primary key?

0 Answers  


What is failover clustering overview?

0 Answers  


What is dynamic cursor in SQL SERVER?

0 Answers  


Categories