菜鸟问题：oracle sql语句问题？

[jamesqsj]

刚接触ORACLE 几天，我想用 select 语句查询表单，
select * from table
可是我只想取最新的 4 笔数据，该怎么些 select 语句啊？
请各位指点，多谢！！

[luyuen]

select * from table where rownum<=4

[yjmfdm]

select aa from (select * from table order by your_column) where rownum<=4

[yjmfdm]

select aa from (select * from table order by your_column) aa where rownum<=4

[zhangshuycc]

yjmfdm(SHMILY)'s is ok

[chanet]

用 rownum