返回每个组的最大值，但当存在平局时，在MySQL中返回id较小的组

SELECT group_id, MAX(value) AS max_value
FROM your_table
GROUP BY group_id
HAVING COUNT(*) = 1
UNION ALL
SELECT t1.group_id, t1.value AS max_value
FROM your_table t1
INNER JOIN (
    SELECT group_id, MAX(value) AS max_value
    FROM your_table
    GROUP BY group_id
    HAVING COUNT(*) > 1
) t2 ON t1.group_id = t2.group_id AND t1.value = t2.max_value
ORDER BY group_id;