Is there any way to offset data starting from the bottom of the data?
Offset happens where it removes the first data on top, but could it possible to remove data starting from the bottom.
I tried limit, but it deleted my first few latest records.
I wanted to get the latest record and omit the old records. Actually I wanted to do a listview where it display the top 3 latest records.
And when the user click the load more button, the other messages will appear. But when a new message appear, the top 3 messages will not be replaced by the new records, instead display the top 3 messages + new records until the user click refresh and the record will query the latest top 3 records.
Thank you.
Java Android SQLite Alternative to offset, Android