select * from(select emp.*,Dense_Rank() over(order by salary desc) as ranki

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

Question Posted / tanay chaudhary

36 Answers
72842 Views
Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
E-Mail Answers

Answer Posted / tanay chaudhary

select * from(select emp.*,Dense_Rank() over(order by salary desc) as ranking from emp)as e where e.ranking in(1,2)

//emp=table name
//salary=column name

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of triggers are there?

1004

Does a server store data?

866

Write an SQL query to obtain the 2nd highest salary.

1022

Explain important index characteristics?

985

What is auditing in sql server?

883

Explain different types of locks in sql server.

1013

Distinguish between nested subquery and correlated subquery?

975

What are the different acid properties?

1014

What is an execution plan? When would you use it?

921

What is a full text index?

871

How do I open a .db file?

975

Write a SQL queries on Self Join and Inner Join.

987

What is the parse query button used for?

982

What is scalar user-defined function?

1001

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

957