MySQL Select Row With Most Recent Date Per User

May 28, 2019 5:28 pm by ATS Staff

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