I have a table that has data that looks like: +----+---------------------+-------+---------+ | id | recdate | mount | perused | +----+---------------------+-------+---------+ | 1 | 2004-05-20 10:46:12 | QUAR | 80 | | 2 | 2004-05-20 11:05:11 | QUAR | 99 | | 2 | 2004-05-20 11:33:27 | ROOT | 99 | | 2 | 2004-05-20 11:33:34 | QUAR | 88 | +----+---------------------+-------+---------+
I'm trying to work out a query that would list the latest entry per id, per mount, and not having much luck. In this case, the result would be 1,QUAR,80 2,ROOT,99 2,QUAR,88 (there are a few other fields to be displayed, but I'll take a base query and adapt). Can anyone give me a shove in the right direction ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]