MySQL : Get latest SCORE for each users where quiz_id = something

Vote count:

0

So here's my table :

id     |     quiz_id     |     user_id     |     date_replied     |     score

1             1                  1           2014-06-04 10:11:47         50
2             1                  1           2014-06-04 20:52:53         90
3             1                  5           2014-06-05 14:22:59         80
4             1                  5           2014-06-06 18:23:41         70

What I want is to get the latest score for each user_id where the quiz_id is 1 for example.

So for the quiz_id = 1; it would return :

id     |     quiz_id     |     user_id     |     date_replied     |     score

2             1                  1           2014-06-04 20:52:53         90
4             1                  5           2014-06-06 18:23:41         70

Is there a way to do this in MySQL ?

Thank you !

asked 32 secs ago

user3057186

11