David Ryder David Ryder - 5 months ago 9
MySQL Question

MySQL query - using SUM of COUNT

This query:

SELECT COUNT(source) AS count
FROM call_details
GROUP BY source
HAVING count >1


Returns about 1500 (the number I'm looking for) results with only the count field. How could I also return the sum of all count fields? When I try

SELECT COUNT(source) AS count,
SUM(count) as total
FROM call_details
GROUP BY source
HAVING count >1


I get an 'Unknown column 'count' in 'field list' error.

And

SELECT COUNT(source) AS count,
SUM(COUNT(source)) as total
FROM call_details
GROUP BY source
HAVING count >1


gives me an 'Invalid use of group function'

Any ideas? I can do a
mysql_num_rows($result)
of the first set (to get the info I need) but I really want to do it through MySQL.

Answer
SELECT COUNT(count) FROM (SELECT COUNT(source) AS count
FROM call_details
GROUP BY source
HAVING count > 1) as A
Comments