Selecting the most recent row for each user

Question

I have a table with columns user_id, time_stampand activitywhich I use to transcode user actions for the audit log.

Now I would like to get the latest timestamp for each unique one user_id. How to do it?

+3

Mawg May 23 '11 at 11:39

2 answers

The following query should be what you want ...

select user_id,max(time_stamp) from yourtable group by user_id order by user_id, time_stamp desc

+3

Oliver m grech May 23 '11 at 11:43

Aj. · Accepted Answer · 2011-05-23T11:41:12+0000

SELECT MAX(time_stamp), user_id FROM table GROUP BY user_id;