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
Getting Data each row from query?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- Posts: 1
- Joined: Tue Aug 13, 2019 8:53 am
Re: Getting Data each row from query?
The very simplest answer to your question is here:
For more learning and thoughts just comment in this answer.
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