mysql 查询所有用户最后一次打卡记录

SELECT
	name,
	time
FROM
	zcl a
 WHERE
	EXISTS 
      (SELECT 1 from zcl b WHERE a.time>b.time  null and a.name=b.name) 
       or
      (SELECT 1 from zcl c WHERE a.name=c.name GROUP BY a.name HAVING count(c.name)=1)