MySQL查找最近的一条数据

<!--查询最近一次记录-->
<select id="findRecent" resultMap="recentMap">
   SELECT r.time, r.afterorbefor FROM `result_list` r
   WHERE time = (SELECT MAX(time) FROM result_list)
   AND account = #{account}
</select>