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 |
How do I know if I have sql express or standard?
Is sql better than access?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is the difference between null value, zero, and blank space?
What is pl sql package?
How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?
What are crud methods?
Store procedure will return a value?
Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974
How do I truncate a sql log file?
What is composite data type in pl sql?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba