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]

Reply via email to