select * from sys.ruan where rownum =(select max(rownum) from sys.ruan);

[put2006]

SQL> select * from sys.ruan where rownum =(select max(rownum) from sys.ruan);

FIRST SECOND DATETIME
----- ------ -----------

Executed in 0.016 seconds

我表格中有记录的阿，怎么会找不到最后一行的呢？

[luxuezhu]

不能rownum =2、3。。。
只能ROWNUM=1

[luxuezhu]

select * from sys.ruan where rownum <=(select max(rownum) from sys.ruan)
minus
select * from sys.ruan where rownum <(select max(rownum) from sys.ruan);

[powar]

用以下语句可以实现你所要的功能:
select * from
(select rownum trwnm,t.* from sys.ruan t) a,(select max( rownum) rwnum from sys.ruan ) b
where a.trwnm = b.rwnum