oracle数据库按照日期排序后获取第一条数据SQL 1

select *  from (select * from 表名 where 条件 order by 排序日期 desc) where rownum=1; 　

 select *  from (select * from TABLE where STATE = 3 order by TIME desc) where rownum=1;