在SQL查询中分组COUNT的SUM [英] SUM of grouped COUNT in SQL Query

问题描述

我有一个包含2个字段的表格：

I have a table with 2 fields:

ID  Name
--  -------
1   Alpha
2   Beta
3   Beta
4   Beta
5   Charlie
6   Charlie

我想按名称，count和一行SUM对它们进行分组

I want to group them by name, with 'count', and a row 'SUM'

Name     Count
-------  -----
Alpha     1
Beta      3
Charlie   2
SUM       6

我如何写一个查询以在表下添加SUM行？

How would I write a query to add SUM row below the table?

推荐答案

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

这篇关于在SQL查询中分组COUNT的SUM的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！