aap bjp congress sum
1 2 5 8
我想显示票数的总和。 如上表输出。
下面是我的SQL查询
请建议我如何获得回声票数的总和。
SELECT RES.PARTYNAME,COUNT( RES.CONSTITUENCY ) AS VOTESCOUNT FROM voter_count RES JOIN (SELECT CONSTITUENCY, MAX(VOTES) AS VOTES FROM voter_count
GROUP BY CONSTITUENCY)MAXS USING ( VOTES, CONSTITUENCY ) GROUP BY PARTYNAME LIMIT 0 , 1000
我认为
下面的查询应该适合您:
SELECT SUM(x.VOTESCOUNT) AS VOTESUM FROM (
SELECT RES.PARTYNAME,COUNT( RES.CONSTITUENCY ) AS VOTESCOUNT FROM voter_count RES JOIN (SELECT CONSTITUENCY, MAX(VOTES) AS VOTES FROM voter_count GROUP BY CONSTITUENCY)MAXS USING ( VOTES, CONSTITUENCY ) GROUP BY PARTYNAME LIMIT 0 ,1000
) x;
投票总和将为您提供总票数
根据你的表格,
SELECT SUM(partyname) AS total_parties, SUM(votes) AS total_votes FROM table_name;
这是你想要的吗??您的问题不清楚,查询与描述无关...
重复 SQL 查询以计算组计数的总和
如果您的列值是按定义的,则可以使用以下静态查询
SELECT
count(CASE WHEN partyname = 'BJP' THEN pagecount END) `BJP`,
count(CASE WHEN partyname = 'AAP' THEN pagecount END) `AAP`,
count(CASE WHEN partyname = 'Other' THEN pagecount END) `Other` ,
count(CASE WHEN partyname = 'BJP' THEN pagecount END) +
count(CASE WHEN partyname = 'AAP' THEN pagecount END)+
count(CASE WHEN partyname = 'Other' THEN pagecount END) `Sum`
FROM test_vote
您可以使用小提琴链接,我已经使用示例数据创建了。
如果要拥有动态列,则可以使用数据透视表,该表将以表格格式为您提供动态输出。
希望这会有所帮助!
从表中选择(从表中选择总和(票数(,政党名称,按政党名称分组的表格中的计数(id(
从表中选择总和(票数(//给出总票数//其余给出政党名称明智投票