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

Differentiate sql server reporting services vs. Crystal reports?

187

How many columns can exist together per table?

1102

When we should use and scope of @@identity?

952

Write a sql query to display the current date?

1028

What is mscorsvw.exe - process - microsoft .net framework ngen?

900

How to use subqueries with the exists operators in ms sql server?

1058

what is a check constraint?

1038

Does partitioning ssd reduce performance?

846

What happens if you add a new index to large table?

882

Tell me extended events in sql server 2008?

949

How adventureworkslt tables are related?

879

How is sql server used?

907

What is data modeling and Reterminal integrity?

1905

What are commonly used mssql functions in php?

999

What is role playing dimension with two examples? : sql server analysis services, ssas

953