求一条SQL语句或函数

Question

select * from (select * from 表 order by 日期 desc) where rownum<2

Answer 1

select * from tbname 
where abs(dtcol-sysdate)=(select min(abs(dtcol-sysdate)) from tbname)

Answer 2

select * from
(select a.*,row_number() over(order by col_date desc) rm from tabname a)
where rm=1

Answer 3

(select * from 表名)
minus
(select * from 表名 where rownum < (select count(*)  from 表名));

Answer 4

select * from tablename 
where abs(MONTHS_BETWEEN(TO_DATE(dtcol),sysdate))
      =(select min(abs(MONTHS_BETWEEN(TO_DATE(dtcol),sysdate)))from tablename )

Answer 5

select * from where rowid in 
(select last_value(rowid) over(order by rownum) lvalue from tablename)