在下面的代码中,我从排名表中添加了Fanbase、coach、TeamRanks、组织和Kicker。它返回每行的总和作为合计。但是,我不确定如何显示合计的最大值。我不需要完整的加法列表。
Select
ID,
(Fanbase + Coach + TeamRanks + Organization + Kicker) as total,
Fanbase,
Coach,
TeamRanks,
Organization,
Kicker
from Ranks;
这将返回每一列的总数,但我需要max。合计的值。
Team Fanbase Coach TeamRanks Organization Kicker
Chargers 80 60 29 18 10
Patriots 100 100 32 32 20
RAMS 80 90 30 25 23
https://stackoverflow.com/questions/55799891
复制相似问题