find second largest value in a column

[rakesh repala]

please help me find the second largest value in a column

write a query using oracle 8i

[Jan Cumps]

Hi Rakesh,
Did you try to write such a query yourself?
Can you show us how far you got?

Regards, Jan

[rakesh repala]

select sal from emp e1 where 2=(select count* from emp e2 where e1.sal>e2.sal)

regards
------

[pradeep singh]

Hi



Select sal from (select max(sal) from emp)
where ROWCOUNT<=1
order by sal desc


I think it will work fine to get second highest salary .