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 |
Where is dbms used?
How is data stored in dbms?
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
1 Answers Flextronics, Hexaware, SQL Star,
What is dbms explain in brief?
what is difference between primary key and unique key ?
Explain the process of the user request and data generating?
Explain the general syntax for a SELECT statements covering all the options.
Explain about relational database management systems?
agregator gives one to many records or many to one record
How to use online Backups?
What is the maximum length of an extended property?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.