Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
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;