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

Categories >> Software >> Databases >> SQL Server
Suggest New Category

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

Question Posted / kuttislg

36 Answers
75081 Views
Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / krishna

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

Is This Answer Correct ?

3 Yes

7 No

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

Answer / uday

select * from Emp e where 1=(select count(Distinct
d.esal)from emp d where d.esal>e.esal)

i am sure that it should work.

Any thing wrong plz inform me

Is This Answer Correct ?

5 Yes

9 No

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

Answer / k.elumalai

select max(salary)from emp where salary <(select sum(salary)
from emp)

Is This Answer Correct ?

6 Yes

12 No

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

Answer / 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

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

Answer / santhosh kumar

select Distinct Top 2 Salary from EMP order by Salary desc

Is This Answer Correct ?

7 Yes

15 No

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

Answer / sivashankar.soma

select ename,sal from emp E where 1=(select count(*) from
emp where E.sal<sal)

Is This Answer Correct ?

16 Yes

29 No

Post New Answer