Getting Data each row from query?

The place to discuss anything and everything about running your LiveCode on Android

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, kevinmiller

Post Reply
katiequinn
Posts: 1
Joined: Thu Aug 08, 2019 10:32 am

Getting Data each row from query?

Post by katiequinn » Thu Aug 08, 2019 10:35 am

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
Posts: 1
Joined: Tue Aug 13, 2019 8:53 am

Re: Getting Data each row from query?

Post by vijaydeveloper » Tue Aug 13, 2019 8:58 am

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.

Post Reply

Return to “Android Deployment”