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

Does view occupy space?

887

What is subquery? Explain the properties of a subquery?

927

Difference between report and query parameter. Why do we need different type of parameter?

906

What is change data capture (cdc) feature?

1001

Why SQL Agent is used?

1067

Can you roll back the ddl statement in a trigger?

915

What it means to be triggered?

914

What is the difference between functions and scalar functions?

1127

What is difference between group by and having?

911

What is the full form of ddl?

866

How to get the definition of a stored procedure back?

922

Tell me what is use of except clause? How it differs from not in clause?

902

What is etl - extraction, transformation, and loading?

860

How to return the top 5 rows from a select query in ms sql server?

1076

Write down the syntax and an example for create, rename and delete index?

925