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.