怎么样取出表中前5个记录?

[purplejason]

select top 5 * from table不行.那在Oracle中是怎么做的呢

[jiezhi]

select * from table1 where rownum<=5

[hrb_qiuyb]

如上。

[洪十二]

select * from table1 where rownum<6

[skyingeye]

select *
from tablename
where rownum<=5,

[beckhambobo]

select * from (select rownum rm,a.* from table a where....) where rm<=5;

[lynx]

个人严重同意骆驼！

[keisar]

select * from table1 where rownum<=5