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 |
What are the two types of exceptions in pl/sql?
What is input buffer in sql*plus?
what are %TYPE and %ROWTYPE? what is the difference?
7 Answers ICICI, Saama Tech, Sail,
what are date and time functions in mysql? : Sql dba
How many triggers can be applied to a table?
What is delete command in sql?
Differentiate pl/sql and sql?
Is pl sql better than sql?
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
What is the current version of sql?
Why is sql important?
What is having clause in sql?