php - 如何显示group by中的所有列

Question

我有两个表 team 和 bobotteam，然后我尝试了这个查询:

SELECT team.id , bobotteam.teamfight/MAX(bobotteam.teamfight)
    FROM team
    INNER JOIN bobotteam on team.id = bobotteam.id

为什么数据只显示 1 个数据，即使我在 bobotteam 表中有两个数据。图片

Answer 1

请试试这个:

SELECT team.id , bobotteam.teamfight/(select MAX(bobotteam.teamfight) from bobotteam)
FROM team
INNER JOIN bobotteam on team.id = bobotteam.id