LiveCode Forums

The very simplest answer to your question is here: select * from ( select username, date, value, row_number() over(partition by username order by date desc) as rn from yourtable ) t where rn = 1 For more learning and thoughts just comment in this answer.