select empname,sal from empdpt e where 1=(select count(*) from empdpt wher

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

Question Posted / karan

Answer Posted / karan

select empname,sal from empdpt e where 1=(select count(*) from
empdpt where e.sal<sal)

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Tell me something about security and sql azure?

114

How to add additional conditions in SQL?

1022

How to create percentile function?

151

How to verify a login name with sqlcmd tool?

1214

How does the report manager work in SSRS?

148

How to create a simple user defined function in ms sql server?

1015

How many categories of data types used by sql server?

1010

explain different levels of normalization? : Sql server database administration

1001

How to make conditional sum in ssrs?

177

Define union, union all, minus, intersect?

974

How column data types are determined in a view?

956

What is query optimizer in sql server?

1018

Describe triggers features and limitations?

987

Why functions are used in sql server?

957

Comment,Datatypes are unlimited

2057