Code:
SELECT name, alter FROM table ORDER BY alter DESC GROUP BY name
So würd's auch gehen.