write the query for find the top 2 highest salary in sql
server
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Answer / ravi pahuja
selecl distinct top 2 salories from emp order by salory desc
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / girish
select max(salary) from emp where sal<(select max(salary)
from emp
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
Accidentally i deleted my table. How can i get that table?
What are the different Topologies in which Replication can be configured?
syntex of insert
Explain the purpose of indexes?
What is a scheduled job or what is a scheduled task?
What is the order in which the sql query is executed?
Explain what is the difference between union and union all?
What are the system database in sql server 2008?
What is a covering index?
What functions can a view be used to performed?
Is INSTEAD OF trigger directly applicable to Table ?
How do I create a trace in sql server?