Search found 1 match
Search found 1 match • Page 1 of 1
- Tue Aug 13, 2019 8:58 am
- Forum: Android Deployment
- Topic: Getting Data each row from query?
- Replies: 1
- Views: 307
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.