SUM of grouped COUNT in SQL Query SUM of grouped COUNT in SQL Query sql sql

SUM of grouped COUNT in SQL Query


sql count sum 

SELECT name, COUNT(name) AS countFROM tableGROUP BY nameUNION ALLSELECT 'SUM' name, COUNT(name)FROM table

OUTPUT:

name                                               count-------------------------------------------------- -----------alpha                                              1beta                                               3Charlie                                            2SUM                                                6

sql count sum 

SELECT name, COUNT(name) AS count, SUM(COUNT(name)) OVER() AS total_countFROM Table GROUP BY name

sql count sum

Without specifying which rdbms you are using

Have a look at this demo

SQL Fiddle DEMO

SELECT Name, COUNT(1) as CntFROM Table1GROUP BY NameUNION ALLSELECT 'SUM' Name, COUNT(1)FROM Table1

That said, I would recomend that the total be added by your presentation layer, and not by the database.

This is a bit more of a SQL SERVER Version using Summarizing Data Using ROLLUP

SQL Fiddle DEMO

SELECT CASE WHEN (GROUPING(NAME) = 1) THEN 'SUM'            ELSE ISNULL(NAME, 'UNKNOWN')       END Name,       COUNT(1) as CntFROM Table1GROUP BY NAMEWITH ROLLUP

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last