find the third highest salary?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / venkatk

23 Answers
45356 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

find the third highest salary?..

Answer / anu

select *
FROM (select emp1.* ,rownum rnum
from ( select * from emp order by sal_amount desc ) emp1
where rownum<=3)
where rnum >=3

Is This Answer Correct ?

1 Yes

0 No

find the third highest salary?..

Answer / farrukh shaikh

select vu.sal from
(select DENSE_RANK() over(order by sal desc) as sr,
sal from emp) vu
where vu.sr=3

Is This Answer Correct ?

3 Yes

3 No

find the third highest salary?..

Answer / meher

SELECT SAL FROM EMP A WHERE &N= (SELECT COUNT(DISTINCT) SAL
FROM EMP B WHERE A.SAL<B.SAL)

--Pass the value for N as 2 to get 3rd highest salary.
--pass 0 for highest sal,1 for 2nd highest,2 for 3rd
highest and so on....

Is This Answer Correct ?

6 Yes

6 No

find the third highest salary?..

Answer / pradeep

select * from emp where sal in(select min(sal) from (select
sal from emp order by sal
desc) where rownum <= 3);

Is This Answer Correct ?

3 Yes

3 No

find the third highest salary?..

Answer / gautam

select * from (
SELECT ROWNUM as RANK, ename, sal
FROM (SELECT ename,sal FROM emp ORDER BY sal DESC)
WHERE ROWNUM <= 3)
where rank=3

Is This Answer Correct ?

1 Yes

1 No

find the third highest salary?..

Answer / deepak kumar

SELECT sal FROM empORDER BY sal DESC LIMIT 2 , 1

Is This Answer Correct ?

0 Yes

0 No

find the third highest salary?..

Answer / yankee

select * from (select * from <table_name> order by salary
desc)where rownum<4

---this way u can get the record of the top 3 salaries and
easily filter out the 3rd positioned salary from there.

Is This Answer Correct ?

4 Yes

5 No

find the third highest salary?..

Answer / mousumi dalai

select min(sal) from emp where sal in
( select sal from
(select sal from emp order by sal desc)
where rownum<=3)

Is This Answer Correct ?

0 Yes

1 No

find the third highest salary?..

Answer / anil pednekar

select * from (select sal from table1 group by sal ) where
row num=3

Is This Answer Correct ?

1 Yes

2 No

find the third highest salary?..

Answer / satish prajapati

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

Is This Answer Correct ?

2 Yes

4 No

Post New Answer