Re: Error with max and group by

[Perrin Harkins]

On Fri, Jun 20, 2008 at 10:50 PM, Joe Pearl <joe@stripped> wrote:
> I want to get back only the most recent entry for each person and I don't
> care about the order.  I want the result to show Jim with the acq_date of
> "2008-01-03", Mary and Sally with the location and date for all of them.

http://dev.mysql.com/doc/refman/5.0/en/example-maximum-row.html

- Perrin