“在组中选择max”的最佳性能查询?

I have a simple table comments (id INT, revision INT, comment VARCHAR(140))(id INT, revisio