``` select A.FUSERNAME 用户实名,A.FOCCURTIME 最晚登录时间 from t_log_app A inner join (select FUSERID,max(FOCCURTIME) FOCCURTIME from t_log_app group by FUSERID) B on A.FUSERID = B.FUSERID and A.FOCCURTIME=B.FOCCURTIME order by A.FOCCURTIME desc ```