查找每組含有最大欄位的整條記錄的方法_MySQL吧

作者共發了1篇帖子。

1樓 120.94.223.* 2017-6-13 11:00

表中有ID, Name, Value欄位。

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