CODE EXAMPLE FOR SQL

select row with latest date mysql

SELECT id, MAX(user) as user, MAX(time) as time, MAX(io) as io FROM lms_attendance GROUP BY id;