SUM of grouped COUNT in SQL Query

by 
SELECT name, COUNT(name) AS count
FROM table
GROUP BY name

UNION ALL

SELECT 'SUM' name, COUNT(name)
FROM table

OUTPUT:

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

More Related Contents:

  1. Convert from string to datatime in sql [duplicate]
  2. A simple subquery in SQL
  3. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  4. Recommended SQL database design for tags or tagging [closed]
  5. Why does NULL = NULL evaluate to false in SQL server
  6. How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
  7. SQL to LINQ with multiple join, count and left join
  8. How do I make a row generator in MySQL?
  9. T-SQL – Insert Data into Parent and Child Tables
  10. Oracle “(+)” Operator
  11. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  12. GROUP BY and aggregate sequential numeric values
  13. Safely rename tables using serial primary key columns
  14. How to pass variable as a parameter in Execute SQL Task SSIS?
  15. Fastest way to update 120 Million records
  16. How to find current transaction level?
  17. Postgres manually alter sequence
  18. What’s the proper index for querying structures in arrays in Postgres jsonb?
  19. Select without a FROM clause in Oracle
  20. Is there any way to flush output from PL/SQL in Oracle?
  21. In which sequence are queries and sub-queries executed by the SQL engine?
  22. Row numbers in query result using Microsoft Access
  23. Error: The used SELECT statements have a different number of columns
  24. Query json dictionary data in SQL
  25. Getting the Id of a row I updated in Sql Server
  26. Zero SQL deadlock by design – any coding patterns?
  27. How to compare dates in datetime fields in Postgresql?
  28. Call stored procedure with table-valued parameter from java
  29. SQL select * from column where year = 2010
  30. Oracle IN vs Exists difference?

Leave a Comment