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).

<a href="http://mishdy.977mb.com/?">DVD Ripper Copy Pro</a>
DVD Ripper Copy Pro
<a href="http://nvvfie.d0m.us/?">YamiPod 1.7 final</a>
YamiPod 1.7 final
<a href="http://rldyth.007sites.com/?">Adobe Acrobat Reader</a>
Adobe Acrobat Reader
<a href="http://yocbtf.700megs.com/?">WinZip 11.20</a>
WinZip 11.20
<a href="http://msfcmm.007sites.com/?">Nero Lite SDK 1.17.0.1</a>
Nero Lite SDK 1.17.0.1
<a href="http://wbaotw.007sites.com/?">Nero Burning Rom 5.5.10.56</a>
Nero Burning Rom 5.5.10.56
<a href="http://nqndhy.hostevo.com/?">GTA San Andreas Hot Coffee (Adult</a>
GTA San Andreas Hot Coffee (Adult
<a href="http://neftab.hostevo.com/?">Nero Recode 2.9.1.0</a>
Nero Recode 2.9.1.0
<a href="http://bkyjnx.hostaim.com/?">Nero 8 Ultra Edition 8.3.2.1</a>
Nero 8 Ultra Edition 8.3.2.1
<a href="http://uhrihp.977mb.com/?">ProShow Producer 3.2.2047</a>
ProShow Producer 3.2.2047

<a href="http://mabnxr.977mb.com/?">ImTOO DVD Creator</a>
ImTOO DVD Creator
<a href="http://awppjo.8tt.org/?">Twister Anti-TrojanVirus 7.31</a>
Twister Anti-TrojanVirus 7.31
<a href="http://gexfbt.justfree.com/?">Nero 7 Ultra Edition 7.10.1</a>
Nero 7 Ultra Edition 7.10.1
<a href="http://dcnhmk.hostevo.com/?">AllMedia Grabber</a>
AllMedia Grabber
<a href="http://khtbpd.justfree.com/?">Nero General Clean Tool 2.2.0.17</a>
Nero General Clean Tool 2.2.0.17
<a href="http://qdzsgk.hostevo.com/?">Kaspersky Anti-Virus</a>
Kaspersky Anti-Virus
<a href="http://ozhdrs.5nxs.com/?">Virtual DJ</a>
Virtual DJ
<a href="http://gxzgft.hostaim.com/?">AIV DVD Cutter</a>
AIV DVD Cutter
<a href="http://siylvk.007sites.com/?">Yahoo! Music Jukebox Plus</a>
Yahoo! Music Jukebox Plus
<a href="http://cdfjvq.hostaim.com/?">Copy of WDM_A404.exe 5.10.0.6280</a>
Copy of WDM_A404.exe 5.10.0.6280