Hi, On Thu, Mar 20, 2008 at 10:35 AM, Edward Corbett <[EMAIL PROTECTED]> wrote: > 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.
Try the techniques I wrote about here: http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
