sql查询获取计数值的总和

Question

   aap      bjp       congress          sum
    1        2           5               8

i want to display sum of votescount. like above table output.

below is my sql query

plz suggest me how to get sum of echo votescount.

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

Answer 1

I think below query should work for you:

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;

VOTESUM will give you total sum of VOTESCOUNT