write the query for find the top 2 highest salary in sql
server
Answer Posted / kapil singh chauhan
select * from
(select ID,Salary from employee order by Salary desc)
where rownum < 3
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is the simplest way to create a new database in ms sql server?
What are the types of database schema? : sql server analysis services, ssas
Explain about protocol layer present in SQL server?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What are rest-style architecture's?
how many bits ip address consist of? : Sql server database administration
What is the use of for clause?
What is table-valued sub query?
What is difference between temp table and cte?
Write a sql query to display the current date?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What are the properties of sub-query?
What does this statement do @@rowcount?
How do I schedule a sql server profiler trace?
What is difference between views and tables?