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 synonym?

722

What is self join in sql server joins?

549

How to delete a database in ms sql server?

550

Ways to improve the performance of a SQL Azure Database?

103

Find columns used in stored procedure?

520

What is update locks?

505

List few advantages of stored procedure.

526

What is awe?

558

What are sql server functions?

503

What does it mean to manipulate data?

548

Will the writetext statement activate a trigger?

560

How to use clusters?

541

What is resource db in sql server?

583

Can select statements be used on views in ms sql server?

574

what is datawarehouse?

641