select * from ( select dense_rank() over (order by salary desc) rno,* fro

write the query for find the top 2 highest salary in sql
server

Question Posted / adiseshu

Answer Posted / adiseshu

select * from (
select dense_rank() over (order by salary desc) rno,* from
employees ) as a where rno in(1,2)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you Implement SSIS Packages in your Project?

1889

What does it mean to invest in the index?

929

What is the default schema of your login session in ms sql server?

1016

How to create a new login name in ms sql server?

1025

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

948

Explain what are various ways to enhance the ssrs report?

1014

What is function of ROLLUP ?

1057

How to use order by with union operators in ms sql server?

987

What is in place upgrade in sql server?

1011

What stored by the model?

1009

What do you mean by subquery?

1051

What are the extra roles available in msdb? : sql server security

1101

What is attribute? : sql server analysis services, ssas

996

What is the use of sign function?

1069

What are Row versions of DataRow?

997