Selecting the most recent entry for each object.

[Edward Corbett]

Hi,

 

I have a load of reviews in a table and, for each person I want to pull out
the most recent review. 

 

So, if I wanted to do this for a single person I would order by date desc
and use "limit 1". But I'm not sure how to do this in bulk.

 

Thanks.