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
What is Lock table in SQL?
How do you troubleshoot errors in a SQL Server Agent Job?
What is similarity and difference between truncate and delete in sql?
What is normalization 1nf 2nf 3nf?
How do I view a script in sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
List the various tools available for performance tuning?
How exceptions can be handled in sql server programming?
How to remove duplicate rows from table except one?
How to declare and use cursor variables?
What are the common performance issues in sql server?
List the data types available in mssql?
What is set nocount on?
Define outer join?
What is postgresql server?