I want to have Grand total of Count(*)

[inamul]

I want to see how many people have registered from Countries and also want to Sum the total

Table fields
1. Name,
2. Email
3 Country

I use this query to get number of people registered against country

SELECT count(*) as COUNT , country as COUNTRY
FROM `epoc_vreg_intersec` group by country
 

COUNT     COUNTRY
1      
1     Azerbaijan
1     Bahrain
1     Canada
1     Germany
5     Iran
1     Japan
2     Jordan
7     Kuwait
4     Lebanon
2     Libyan Arab Jamahiriya
2     Oman
1     Pakistan
2     Qatar
2     Romania
12     Saudi Arabia
1     Syria
2     Thailand
2     Turkey
60     United Arab Emirates
5     United Kingdom
 

Above query works but but i also want total of count field also using same query.

[mwasif]

Thanks for using CODE tags. But use it where it requires.

Use WITH ROLLUP option

SELECT count(*) as COUNT, country as COUNTRY
FROM `epoc_vreg_intersec` GROUP BY country WITH ROLLUP;

[amitpatel66]

Thanks for using CODE tags. But use it where it requires.

Use WITH ROLLUP option

SELECT count(*) as COUNT, country as COUNTRY
FROM `epoc_vreg_intersec` GROUP BY country WITH ROLLUP;

 
SELECT count(*) AS COUNT, SUM(COUNT(*)) OVER() FROM epoc_vreg_intersec GROUP BY country
 
 

[mwasif]

 
SELECT count(*) AS COUNT, SUM(COUNT(*)) OVER() FROM epoc_vreg_intersec GROUP BY country
 
 

Hi amitpatel66,
Is this a valid MySQL syntax?