统计分组返回的记录数

Count number of records returned by group by(统计分组返回的记录数)

问题描述

如何统计一个group by query返回的记录数，

How do I count the number of records returned by a group by query,

例如:

select count(*) 
from temptable
group by column_1, column_2, column_3, column_4

给我，

1
1
2

我需要数一下上面的记录，得到 1+1+1 = 3.

I need to count the above records to get 1+1+1 = 3.

推荐答案

您可以在另一个 COUNT 上使用 OVER 子句在一个查询中执行这两项操作

You can do both in one query using the OVER clause on another COUNT

select
    count(*) RecordsPerGroup,
    COUNT(*) OVER () AS TotalRecords
from temptable
group by column_1, column_2, column_3, column_4

这篇关于统计分组返回的记录数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！