Write a query to find second highest salary of an employee.
- 72 Answers
- 109501 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / p
select ename from emp where esal=(select max(esal) from emp
where esal<(select max(esal) from emp));
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / satish
select e1.* from emp where 1=(select e2.sal from emp e2
where e2.sal>e1.sal)
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / kapil deep
SELECT * FROM (SELECT * FROM emp_t WHERE ROWNUM < 3 ORDER
BY salary) WHERE ROWNUM < 2
above query work fine for oracle.
Taking 3 as N give u 3-1=2 i.e 2nd highest
4-1=3 gives u 3rd highest
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / deepak falke
3rd highest sal from account :
SELECT TOP 1 Sal FROM account WHERE Sal IN
(SELECT distinct TOP 3 Sal FROM account ORDER BY Sal DESC)
order by sal
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / vidhya
select max(column name) from table_name where((select max
(column name) from table_name Order by salary Desc) set
difference (select max(column name))
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / krishna kishore
SELECT TOP 1 Salary FROM Employee WHERE Salary IN
(SELECT TOP 2 Salary FROM Employee ORDER BY Salary DESC)
I think this would be the simplest way and high performance
query.
waiting for the comments !!!
| Is This Answer Correct ? | 7 Yes | 11 No |
Answer / muralidhara(minchu)
Select * from epm A where &(n-1)=(select count(*) from emp
B where A.sal < B.sal);
Try this it will work,this will give nth salary ie if u
enter 2 this will give second highest sal
| Is This Answer Correct ? | 13 Yes | 22 No |
Answer / sridhar
Its real simple. Suppose your employees are in a table
called by the same name, and the salaries in a column named
salaries). Lets See te case in which we want the 3 greatest
salaries. Then you Query:
SELECT employees.salary
FROM employees
ORDER BY employees.salary desc
LIMIT 3;
If you want the biggest 5 salaries, you put LIMIT 5, and so on….
| Is This Answer Correct ? | 3 Yes | 16 No |
Answer / krishna
select sal from empa where 1=(select count of sal from emp
b)where a.sal<b.sal
| Is This Answer Correct ? | 9 Yes | 25 No |
Answer / gokulapriya
select * from employee where salary < (select max(salary)
from employee)
(i have written as sub query)
is this right
| Is This Answer Correct ? | 5 Yes | 31 No |
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
What is junit? And what is junit annotation?
List of Test Management Tools??Is Quality Center Test Management tools
Name the frameworks that are used in software automation testing?
I want a code for a following item in TSL Language. Look up a person in database, If not found, add person to the database.
Can you list some other automation testing tools that you are familiar with?
can you ple give me Quality Center interview questions and answer
When will you automate a test?
What criteria do you use when determining when to automate a test or leave it manual?
What is data - driven automation?
I am testing a GIS based application so Can anyone tell me which automation testing tool is best for this application?
How to explain testing life cycle where exactly testing starts after coding stage or after preparing FRS document
WinRunner 
