how to get the salary in descending order with out using
the keyword desc in sql
Answers were Sorted based on User's Feedback
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 |
What are the restraints imposed on the table design by a merge replication?
How to create user messages with print statements in ms sql server?
What are character string data types in ms sql server?
how can u select the Distinct values in the table, table having 20 columns , i want all columns
How can I know what locks are running on which resource?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Why main is user defined function?
How do I perform an unattended install of sql server 2000?
How can we rewrite sub-queries into simple select statements or with joins?
How to find the version of sql server? : sql server database administration
How to convert numeric expression data types by assignment operations?
explain the type of contraints