select a.* from 表名 a,(select employeeid,max(time) time from 表名 group by employeeid) bwhere a.employeeid=b.employeeid and a.time=b.time
表名自己换一下
