Find out the 3rd highest salary?
Answers were Sorted based on User's Feedback
Answer / tathagoto
select sal from (select sal from salary order by sal desc)
where rownum <4;
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / santosh
select level,max(sal) from emp where level=3 connect by
prior sal>sal
group by level;
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / sachin
select * from ( select * from (select * from emp order by
sal desc)
where rownum<=3
order by rownum desc)
where rownum=1
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / xyz
select a.sal from (select distinct(sal) from emp order by
sal desc)a where rownum=3
Is This Answer Correct ? | 2 Yes | 7 No |
Answer / srijith pillai
This will give you third highest salary
select ename, sal from
(Select name, sal, rownum()Over(Order by sal Desc) rt
FROM emp)
where rt = 3;
Is This Answer Correct ? | 13 Yes | 19 No |
Answer / manoj
SELECT min(salary)
FROM (
SELECT e.salary , ROWNUM
FROM emp e
ORDER BY salary DESC
AND ROWCOUNT <=3
)
ROWNUM =3;
Is This Answer Correct ? | 3 Yes | 9 No |
Answer / umesh naik
select max(amount) from (
select distinct amount from temp123
where rownum <= 3
)
Is This Answer Correct ? | 1 Yes | 8 No |
Answer / s.dineshkumar
Select Top 1 Salary from (Select top 3 Salary from Employee
order by salary desc ) a
Is This Answer Correct ? | 0 Yes | 7 No |
Answer / shaiju nair
select min(sal) from (Select sal
FROM emp where rownum<=3
Order by sal desc)
Is This Answer Correct ? | 13 Yes | 25 No |
Is not null in sql?
What is the difference between local and global temporary table?
What is a schema? How is it useful in sql servers?
What do we need to check in database testing?
How to use boolean type in select statement?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is rename in sql?
What is crud diagram?
What is the least restrictive isolation level? : Transact sql
How can analyze query after generating explain plan ?
What is the difference between row level and statement level trigger?
Is it possible to use LONG columns in WHERE clause or ORDER BY?