select * from ( select * from table where name='ss' ORDER BY CREATE_DATE desc) a where rownum <=1 order by rownum desc