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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the advantages of merge replication?

505


What is a trigger what are the advantages of trigger?

524


What are out-of-range errors with date and time literals?

551


What are the types of user defined functions in sql server?

498


What are the disadvantages of indexes?

526






Can You Use Data Mining Models In Ssrs?

97


How to concatenate two binary strings together?

606


What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

675


How do I find the sql server version?

518


How self join is different from outer join?

601


How you can get a list of all the table constraints in a database?

511


What is nolock hint in sql server 2008

630


Can we install sql server 2016 on windows 7?

666


what is a schema in sql server 2005? : Sql server database administration

510


What is the use of stored procedure?

511