要解释我想做什么有点困难(很抱歉,标题很难读),但基本上我想把重复的行和起来,如下所示:
表A:
EntryID| Country | Region | Sales
101 | USA | North | $10
102 | USA | North | $5
103 | USA | South | $15
104 | USA | South | $10
105 | CHINA | North | $5
106 | CHINA | North | $5
107 | CHINA | South | $10
108 | CHINA | South | $20期望输出
EntryID| Country | Region | Sales
101 | USA | North | $15
103 | USA | South | $25
105 | CHINA | North | $10
107 | CHINA | South | $30我该怎么做?
发布于 2016-12-28 18:22:12
SQL语句必须如下所示:
SELECT MIN(EntryID) AS EntryID,
Country,
Region,
SUM(Sales) AS Sales
FROM TABLE
GROUP BY Country,
Region发布于 2016-12-28 18:22:12
虽然缺乏细节,但在我看来,这似乎是一个简单的GROUP BY:
select min(EntryID), Country, Region, sum(sales)
from tbl
group by Country, Regionhttps://stackoverflow.com/questions/41367573
复制相似问题