Lets say i do this: SELECT name, MAX(age) FROM Person GROUP BY name
This will group people who have the same name together, and return the highest age for each group. I want to be able to find the id for the person with the highest age in each group - Ideally, it would be something like this SELECT name, MAX(age), id_for_row_with_max_age FROM Person GROUP BY name Anyone know how to do this? Lindsay ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
