write the query for find the top 2 highest salary in sql
server
Answer Posted / shahid
select * from(select * from Employee order by salary desc) where rowNum<3
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is mapping schema?
List out the difference between union and union all in sql server?
How do I connect to sql server database?
What is the purpose of sql profiler in sql server? : sql server database administration
What are different types of replication in sql server?
Explain transaction server distributed transaction?
How to create a store procedure with encryption?
What is optimistic concurrency?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
Name 3 ways to get an accurate count of the number of records in a table?
What is the difference between web edition and business edition?
Explain something about security and SQL Azure?
Name few of the dcl commands in sql?