SyntaxFix
Write A Post
Hire A Developer
Questions
You can do it with window functions
SELECT t.* FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY usr_id ORDER BY time_stamp DESC) as r FROM lives) as t WHERE t.r = 1