MySQL Select Row With Most Recent Date Per User



SELECT t1.*
FROM attendance t1
WHERE t1.date = (SELECT MAX(t2.date)
                 FROM attendance t2
                 WHERE t2.user = t1.user)