find out the third highest salary?
Answers were Sorted based on User's Feedback
Answer / swaminathan
select *
from (select distinct sal from emp order by sal desc)
where rownum <= 3
Is This Answer Correct ? | 9 Yes | 13 No |
Answer / amitabh sharma
Here are 2 queries for finding 3rd highest salary:
select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);
SELECT * FROM
(
SELECT Ename, SAL, dense_Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMP)
WHERE RANKNEW = 3
Regards,
Amitabh Sharma
Is This Answer Correct ? | 1 Yes | 5 No |
Answer / ruchira
select sal from emp
where sal =
(select sal from
(select distinct sal from emp OrderBy sal desc)
[table alias] where rownum < 4 )
Is This Answer Correct ? | 1 Yes | 5 No |
Answer / sapna rawal
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary ;
n=3.In this case.
Is This Answer Correct ? | 1 Yes | 5 No |
Answer / anirban mitra
SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN (SELECT MAX(SAL)
FROM EMP UNION SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN
(SELECT MAX(SAL) FROM EMP))
Is This Answer Correct ? | 2 Yes | 7 No |
Answer / nagaraj a h
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
Is This Answer Correct ? | 0 Yes | 5 No |
Answer / dayaram & sarfaraz (dost)
select a.empno,a.ename,a.sal from emp a
where &n = (select count(distinct(b.sal)) from emp b where
b.sal>= a.sal
Is This Answer Correct ? | 0 Yes | 5 No |
Answer / asadullahrao
select max(sal) from emp where sal<(select max(sal) from
emp where sal<(select max(sal) from emp))
Is This Answer Correct ? | 1 Yes | 6 No |
How to execute the package in oracle?
Explain how you would restore a database using RMAN to Point in Time?
How do I reset a sequence in oracle?
How to add a new column to an existing table in oracle?
What are the oracle differences between nvl and coalesce
What is a user role in oracle?
What is enter substitution variable in oracle?
What is parameterized cursor in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
Draw E-R diagram for many to many relationship ?
what is exact difference between drop and truncate table.
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?