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


Please Help Members By Posting Answers For Below Questions

What is Lock table in SQL?

987


How do you troubleshoot errors in a SQL Server Agent Job?

535


What is similarity and difference between truncate and delete in sql?

567


What is normalization 1nf 2nf 3nf?

604


How do I view a script in sql server?

505






How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

534


List the various tools available for performance tuning?

465


How exceptions can be handled in sql server programming?

519


How to remove duplicate rows from table except one?

553


How to declare and use cursor variables?

568


What are the common performance issues in sql server?

477


List the data types available in mssql?

498


What is set nocount on?

478


Define outer join?

518


What is postgresql server?

492