How to find 1st, 2nd, 3rd highest using select select statement not using rown

How to find 1st, 2nd, 3rd highest using select select
statement not using rownum

Question Posted / praveen sharma

Answers were Sorted based on User's Feedback

How to find 1st, 2nd, 3rd highest using select select statement not using rownum..

Answer / madhavi

SELECT sal
FROM (SELECT sal, RANK() OVER(ORDER BY sal DESC) AS rnk
FROM emp)
WHERE rnk IN (1,2,3);

Is This Answer Correct ?

14 Yes

3 No

How to find 1st, 2nd, 3rd highest using select select statement not using rownum..

Answer / ajit

select distinct *
from (select e.*,dense_rank()over(order by sal desc) rn from emp e)
where rn in (1,2,3);

Is This Answer Correct ?

0 Yes

0 No

How to find 1st, 2nd, 3rd highest using select select statement not using rownum..

Answer / annada

SELECT e.lastname,e.salary FROM employees e
WHERE 1=(SELECT count(*) FROM employess s
WHERE s.salary>e.salary

Is This Answer Correct ?

1 Yes

2 No