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

What is transact-sql language?

1094

What is a trigger? Why we need it?

996

What are the 2 types of classifications of constraints in the sql server?

1124

How can delete duplicate records in cte in sql server?

964

What the difference between UNION and UNIONALL?

1040

What is for xml in sql server?

1075

How extra digits are handled with numeric data type literals?

966

When would you use the stored procedures or functions?

1000

Do you know sql server 2008 backup compression?

968

What are four major operators that can be used to combine conditions on a where clause?

1054

Do you know spatial data types - geometry and geography in sql server 2008?

1033

Explain subquery and state its properties?

1042

How can you list all the columns in a database?

931

What happens if ntwdblib.dll is missing on your machine?

1144

What is perspective, have you ever created perspective? : sql server analysis services, ssas

917