select * from emp e where 2>=(select count(distinct esal) from emp wh

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

Question Posted / krishna

Answer Posted / krishna

select * from emp e where 2>=(select count(distinct esal)
from emp where e.esal<=esal)

Is This Answer Correct ?

8 Yes

16 No

Please Help Members By Posting Answers For Below Questions

List the ways in which dynamic sql can be executed?

1012

Explain the use of keyword with encryption. Create a store procedure with encryption?

957

Where to find ntwdblib.dll version 2000.80.194.0?

958

What is Command line parameters in PLSQL.?

1125

What is dbcc?

1133

How to return the date part only from a sql server datetime datatype?

1100

What is ssl in sql server?

1072

What is best institute to Learn DotNET And SQL in chennai?

2161

Differentiate sql server reporting services vs. Crystal reports?

200

Explain the types of indexes.

1211

What is spid in sql server profiler?

1097

can you implement data mining in SSRS?

148

What is a derived table?

923

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

989

What is a domain constraint give an example?

1047