find out the third highest salary?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / guest

92 Answers
147680 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

find out the third highest salary?..

Answer / swaminathan

select *
from (select distinct sal from emp order by sal desc)
where rownum <= 3

Is This Answer Correct ?

9 Yes

13 No

find out the third highest salary?..

Answer / rakesh sharma

order by
credit desc

Is This Answer Correct ?

0 Yes

4 No

find out the third highest salary?..

Answer / order by sal

select (sal) as sal from employee

Is This Answer Correct ?

0 Yes

4 No

find out the third highest salary?..

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

find out the third highest salary?..

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

find out the third highest salary?..

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

find out the third highest salary?..

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

find out the third highest salary?..

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

find out the third highest salary?..

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

find out the third highest salary?..

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

Post New Answer