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 |
How to write a query with a right outer join in ms sql server?
Without Using Cursors , How to Select the Selected row??
3 Answers CarrizalSoft Technologies, Wipro,
What is catalog views?
What is difference between foreign key and unique key?
What are key constraints?
Describe in brief authentication modes in sql server.
How do I make a resultset scrollable?
Can we use Truncate command on a table which is referenced by FOREIGN KEY?
Can a table have 2 foreign keys?
How to convert character strings into numeric values?
What are the differences between decimal and float in ms sql server?
How to set database to be read_only in ms sql server?