Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

Answer / kapil singh chauhan

select * from
(select ID,Salary from employee order by Salary desc)
where rownum < 3

Is This Answer Correct ?    4 Yes 3 No

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

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

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

Answer / nilesh

select * from employee2 e where 2=(select count(distinct salary) from employee2
where e.salary<=salary)

Its working.

Is This Answer Correct ?    2 Yes 1 No

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

Answer / ramu

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

Is This Answer Correct ?    6 Yes 6 No

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

Answer / saurabh

Answer 24 is correct , i have checked it.

Is This Answer Correct ?    0 Yes 0 No

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

Answer / mohan c v

select min(salary) from
(select top 2 salary from emp order by salary desc) as a

Is This Answer Correct ?    0 Yes 0 No

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

Answer / priyanka

select salary from emp where rowno=3 order by sal desc.

but this query works only when you have to create index.

Is This Answer Correct ?    0 Yes 0 No

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

Answer / ravi pahuja

selecl distinct top 2 salories from emp order by salory desc

Is This Answer Correct ?    0 Yes 0 No

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

Answer / girish

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

Is This Answer Correct ?    0 Yes 0 No

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

Answer / chandan kumar

Select Top 1 salary from(select top 2 salary from emp_table
order by salary asc)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More SQL Server Interview Questions

What does nvl stand for?

0 Answers  


What is the difference between stored procedure and functions?

0 Answers   MCN Solutions,


Differentiate between a primary key and a unique key.

0 Answers  


What are the properties of primary key?

0 Answers  


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

0 Answers  






Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  


Explain having clause and where clause?

0 Answers  


what is isolation level at dead lock?

0 Answers   Verizon,


How to create function without parameter in sql server?

0 Answers  


Is BCNF better than 2NF & 3NF? Why?

0 Answers   Akamai Technologies,


explain declarative management framework (dmf) in sql server 2008?

0 Answers  


What is the use of keyword with encryption.

0 Answers  






Categories