SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE user_activity ( user_id int, activity varchar(32), activity_date datetime ); INSERT INTO user_activity VALUES (1, 'login', '2020-01-01 15:16:17'), (2, 'login', '2020-01-01 15:18:19'), (3, 'login', '2020-01-01 19:24:41'), (3, 'logout', '2020-01-01 20:08:01'), (1, 'logout', '2020-01-02 03:16:17'); SELECT user_activity.user_id, user_activity.activity, last_activity_date FROM user_activity JOIN ( SELECT user_id, MAX(activity_date) last_activity_date FROM user_activity GROUP BY user_id ) last_activity ON last_activity.user_id = user_activity.user_id AND last_activity.last_activity_date = user_activity.activity_date ORDER BY activity_date DESC;