Write a query to find second highest salary of an employee.
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 |
Tell us how can we handle web-based pop-up?
has anyone attended mr. g c reddy sir classes? whom you guys want me to choose Mr. G C Reddy or Mr. Suresh Reddy ? Please help!!!!!!!!!!!
Why do you want to keep this kind of information in a separate file and not directly in the code?
what are the questions that are generally asked in an interview if a person is having 3-4 years of exp..and in ds exp 2 yrs exp is wd automation testing
Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(
How you will evaluate the tool for test automation?
How you will describe testing activities?
Tell me the fundamental difference between xpath and css selector?
What tools are available for support of testing during software development life cycle?
What are main benefits of test automation?
what is GDC
can anybody tell me " which automation framework u r using?" some interviewer asked this quesion? pls give me answer