SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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_id, activity, activity_date FROM ( SELECT user_id, activity, activity_date, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY activity_date DESC) rn FROM user_activity ORDER BY activity_date DESC ) activities WHERE rn = 1;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear