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
What is a deadlock and what is a live lock?
What is “asynchronous” communication in sql server service broker?
When to use Inner join & when to use subquery?
What is the use of =,==,=== operators?
How to check table values in sql server?
What is a sql join?
What are functions in the sql server?
What is data compression?
What is sql server 2000 work load governor?
How is a full-text index updated?
what is checksum in sql server.........???
What is the difference between executequery () and executeupdate ()?
How to start sql server browser service?
If the job running very slow what is the action you do
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }