表中有ID, Name, Value字段。
SELECT *FROM T AS mainWHERE Value = (SELECT MAX(Value) FROM T WHERE name=main.name);