How do you determine "most recent"? Is it based on the highest ID number
for a person or some datetime value you didn't show us?
This is another form of the groupwise maximum problem described here:
http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html
If after reading the do
If I have a table with fields
ID, NAME, VALUE
and they may be populated like
1, SHAWN, APPLE
2, TOM, BANANA
3, SHAWN, BANANA
4, JACK, GRAPES
5, TOM, APPLE
6, SHAWN, GRAPES
and I want to query all records showing only the most recent records for
each person
Any thoughts?
--
MySQL General Mai
