i want to know about mr.b.kotravel......who has answered for second maxmium sa

i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table

Question Posted / sthiyagu

Answers were Sorted based on User's Feedback

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee t..

Answer / mohan

select max(sal) from emp where sal<(select max(sal) from
emp)

Is This Answer Correct ?

2 Yes

0 No

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee t..

Answer / surya

select * from emp where 2-1=(Select count(distinct(sal)
from emp e where emp.sal<e.sal and ename='mr.b.travel)

Is This Answer Correct ?

0 Yes

0 No

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee t..

Answer / obulesu

select * from (select e.*,dense_rank() over(order by sal desc) r from emp e) where r=2;

Is This Answer Correct ?

0 Yes

0 No