lundi 4 janvier 2016

SQLite how to select row based on a column max

I have the following table

UserID, Cost, date 1. 23. 2015-04-02 2. 17. 2015-03-14 1. 63. 2015-09-23 2. 49. 2013-03-17 2. 12. 2013-04-23 1. 96. 2016-01-01

What I want is a list of USERID & date with the largest cost

So Userid 1 cost 96 date 2016-01-01 Userid 2 cost 49 date 2013-03-17

Thanks

Aucun commentaire:

Enregistrer un commentaire