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
Explain the concept of view and Types of views in SQL server?
What is global temp table?
Explain what role entity and relationship play in an ER diagram.
What is purpose of normalization?
What is the difference between functions and scalar functions?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Explain what are magic tables in sql server?
role of sql sever 2005 in database rather than any other database
List out the differences between the clustered index and non-clustered index in sql server?
How to select true false based on column value in sql server?
Explain the difference between cross join and full outer join?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What are the different types of collation sensitivity?
what are different types of backups available in sql server? : Sql server database administration