查找每组含有最大字段的整条记录的方法, Bar MySQL, Purasbar

The author has 1 post.

Floor 1 120.94.223.* 6/13/17 11:00

表中有ID, Name, Value字段。

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