select e1.sal from emp e1 where 2=(select count(distnct (e2.sal) from emp

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

Question Posted / srinivas

Answer Posted / srinivas

select e1.sal from emp e1 where 2=(select count(distnct
(e2.sal) from emp e2 where e2.sal>=e1.sal)

Is This Answer Correct ?

33 Yes

32 No

Please Help Members By Posting Answers For Below Questions

We need to perform what steps in the following order to work with a cursor?

1170

How to sort query output in descending order in ms sql server?

902

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2019

What is delete query?

898

How to create a view with data from multiple tables?

969

Define cross join in sql server joins?

966

How to list all login names on the ms sql server?

1081

How do users use Report Builder with SQL Server data sources?

146

How to find index size for each index on table?

963

What is the difference between a function and a stored procedure?

1007

How to skip remaining statements in a loop block using continue statements?

935

How can we check the sql server version?

983

What is an index in sql?

962

Explain what is analysis service repository?

929

What is a full text index?

871