From DB (there's also time stamp column not presented in the table)
+-----+---------+
|user | place |
+---------------+
|Name3|Location2|
|Name1|Location1|
|Name2|Location2|
|Name3|Location3|
|Name1|Location2|
|Name4|Location1|
+-----+---------+
I want to query last entry for particular user, for example query for Name3 should return Location2.
Is it possible to do it by sqlite query? Maybe it's easier to take all data to a List and then try to find last entry for particular user?
Aucun commentaire:
Enregistrer un commentaire