KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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.
Tags (comma-separated)
Save Edits
Cancel