Top 3rd value

Hello can any buddy tel me can i write a query to get the top 3rd, 4th value from the table 'emp'?

Hi,
This is the query which will give top 3rd and 4th value.
select *
from(select * from Your_table order by somecoloum desc)
where rownum<5
Minus
select *
from( select * from Your_table order by somecoloum desc)
where rownum<3 ;

Bye
Sheetal

select top1 from (select distinct top3 from table name order by sal desc)

SQL Qureies for retriew 3rd max salary:
Select max(salary) from emp where salary not in (select top 2 salary from emp order by salary desc)

Thanks & Regards
Alagu....

SELECT Min(qty) AS Expr1
FROM (select top 3 qty from cashmemodetail order by qty desc)

select salary from E1 where (4-1)=(select count(distinct(salary)) from E2 where E2.salary>E1.salary).