On Fri, Jun 20, 2008 at 10:50 PM, Joe Pearl <[EMAIL PROTECTED]> 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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to