Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128909 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 kind of tests should not be automated?
I want to learn the data base testing, how can I start my psactice? I already reading the books of basic for data base? If any other books that make my study simple please suggest.
What is Automation Testing Framework
write a programme to insert into elements in array?n finding duplicate characters in given sting?
Describe some problem that you had with automating test tool?
how to re-install QTP 11.0 trial version
List down the primary features of a good automation tool?
How you report bug in to bugzilla
What are the things that one should consider for selecting a project for test automation? For example, stability, etc.
What steps are needed in developing and running a software test?
What testing activities you may want to automate in a project?
What testing activities you may want to automate?
WinRunner 
