select mc from (select t1.key, t1.mc, t1.shijian from table1 t1 order by t1.shijian desc ) where rownum = 1
