表中有ID, Name, Value字段。

SELECT *
FROM T AS main
WHERE Value = (SELECT MAX(Value) FROM T WHERE name=main.name);