Given an employee table, how would you find out the second
highest salary?
Answers were Sorted based on User's Feedback
Answer / sowjanya
Select * from emp where sal=(select Max(sal) from emp where
sal<(select Max(Sal) from emp)
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / trived
select * from emp
where n-1 = (select count(*) from emp e
where emp.salary<e.salary)
in place of n-1 you can keep zero for first hight salary
and 1 for second hightest salary.....etc
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / rony sunny
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 2 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / ravikumar
select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / balindra sahani
select max(sal) from emp
where sal not in (select max(sal) from emp )
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / karna
select top 1 a.salary,* from emp a
where a.salary not in(select top (n-1) b.salary from emp b)
here n is the Nth values:if you want secong highest: keep n
as 2 so the query will become
select top 1 a.salary,* from emp a
where a.salary not in(select top 1 b.salary from emp b)
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / balindra sahani
select max(sal) from emp
where sal not in (select max(sal) from emp order by sal desc )
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mithilesh mishra
Select Max(sal) from emp where sal not in (select max(sal)
from emp)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vivek mohan singh
select salary from tablename order by salary desc limit 1,1;
Is This Answer Correct ? | 2 Yes | 3 No |
How to combine two function together?
Explain about network model?
How is data stored in dbms?
What is a self join? Explain it with an example?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
how will I find the duplicate rows count from employees tablein oracle.
How can I detect whether a given connection is blocked?
What is DB Development software?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Where is dbms used?
Explain about relational database management systems?
Explain the process of the user request and data generating?