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

Define self join?

1078

How can we get count of the number of records in a table?

996

Describe and explain about SQL native client?

1158

What are the difference between “where” and “having” clause in sql server?

1132

What is difference between rownum and row_number?

1024

Can you roll back the ddl statement in a trigger?

1021

What is data modification?

1018

Do you know what is xpath?

1154

What is create statement?

1010

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1099

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

125

In what version of sql server were synonyms released?

1000

Differentiate sql server reporting services vs. Crystal reports?

209

What are orphan records?

986

What is the sql server agent?

1146