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 |
What is the maximum length of an extended property?
How to customize error conditions.
What are defaults? Is there a column to which a default can't be bound?
How can you log an error to the server event log from a stored procedure?
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me
What are the constraints on severity level in raiseerror?
What is dbms explain in brief?
Can you instantiate a COM object by using T-SQL?
explain detail about ftp in datastage?
Explain the family trees and connection by clause.
Explain about a primary key?
How long can an error message be in raiseerror function?