这个怎么样:
SELECT all_fields.* FROM (SELECT id, MAX(rev) FROM yourtable GROUP BY id) AS max_recs LEFT OUTER JOIN yourtable AS all_fields ON max_recs.id = all_fields.id