sql query need to retrive the 5th highest salary from a table

[partha das]

sir

i need a single sql query it may be sub query need to retrive the 5th highest salary from a employee table

[suvam]

U can try this one ----->

select * from (select distinct val from suvam order by val)
where rownum < 6
Minus
select * from (select distinct val from suvam order by val)
where rownum < 5 ;

[pavuluri]

U can try this one ----->

select * from (select distinct val from suvam order by val)
where rownum < 6
Minus
select * from (select distinct val from suvam order by val)
where rownum < 5 ;

select * from emp e where 5=(select count(*) from emp where sal>e.sal)

thanks
srinivas