我有以下结构:
+====================================================================+
+ City | PartyName | VoteCount | VotePercentage +
+--------------------------------------------------------------------+
+ City1 | Party1 | 871 | 1.2 +
+ City2 | Party1 | 580 | 2.3 +
+ City3 | Party1 | 149 | 1.2 +
+ City1 | Party2 | 234 | 0.2 +
+ City2 | Party2 | 533 | 1.3 +
+ City3 | Party2 | 655 | 2.2 +
+====================================================================+此表显示了每个城市的每个政党的选票。我需要一个查询,求和所有的选票计数和每个党的百分比。因此,上表应如下所示:
+=======================================================+
+ PartyName | VoteCount | VotePercentage +
+-------------------------------------------------------+
+ Party1 | 1600 | 4.7 +
+ Party2 | 1422 | 3.7 +
+=======================================================+因此,它应该省略城市,并将每个政党的选票计数和百分比相加。我现在的问题是:
SELECT City, PartyName, VoteCount, VotePercentage
FROM elections
ORDER BY PartyName我尝试过GROUP BY PartyName,但是它只显示了应该出现的一小部分行。我怎样才能得到上面表格中的结果?
发布于 2017-03-01 22:53:13
使用以下内容作为查询:
SELECT PartyName, SUM(VoteCount), SUM(VotePercentage)
FROM elections
GROUP BY PartyNamehttps://stackoverflow.com/questions/42534819
复制相似问题