write the query for find the top 2 highest salary in sql
server
Answer Posted / saritha
select distinct top 2 salary from EMP order by salary desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we solve concurrency problems?
What is the difference in accessing db between sql server vs sql azure?
What is the difference between a local and a global temporary table?
How we can refresh the view?
Explain “@@rowcount” and “@@error” in sql server?
What is the use of commit?
Explain ms sql server reporting services vs crystal reports?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
what is hash nonclustered index
What is a data source or ds? : sql server analysis services, ssas
Distinguish between commit and rollback?
Difference between DELETE and TRUNCATE?
What is the template in sql?
What is key set driven?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?