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