Getting Data each row from query?

[katiequinn]

guys,

I have a sample file I attached along with this post. I want to get the data of each row of my query and display it one at a time in the dialogbox or answer here in livecode I think I almost there but not quiet..

Need your help guys..

Thank you

[vijaydeveloper]

The very simplest answer to your question is here:

Code: Select all

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.