sql中count（*）值的总和 [英] sum of the count(*) values in sql

问题描述

我现在有以下查询我需要计数（*）值的总和我该怎么办

I have the following query now i need the sum of the count(*) values how can i do so

select a.col1 , count(*) count_1  , sum(count_1)
from table1 a join table2 on a.id = b.id

推荐答案

我不确定你想要达到的目的，但请看下面的例子：

I'm not sure what you want to achieve, but have a look at below example:

SELECT F1, COUNT(F1) AS CountOfF1, SUM(F2) SumOfF2
FROM (
	SELECT 1 AS F1, 2 AS F2
	UNION ALL SELECT 1, 5
	UNION ALL SELECT 1, 3
	UNION ALL SELECT 1, 4
	UNION ALL SELECT 2, 12
	UNION ALL SELECT 2, 5
	UNION ALL SELECT 2, 5
	UNION ALL SELECT 2, 15
) AS T
GROUP BY F1

SELECT COUNT(F1) AS DistinctF1Fields, SUM(Q.CountOfF1) AS SumOfCountOfF1
FROM ( 
	SELECT T.F1, COUNT(T.F1) AS CountOfF1, SUM(T.F2) SumOfF2
	FROM (
		SELECT 1 AS F1, 2 AS F2
		UNION ALL SELECT 1, 5
		UNION ALL SELECT 1, 3
		UNION ALL SELECT 1, 4
		UNION ALL SELECT 2, 12
		UNION ALL SELECT 2, 5
		UNION ALL SELECT 2, 5
		UNION ALL SELECT 2, 15
	) AS T
	GROUP BY T.F1
) AS Q

结果1.查询：

Result of 1. query:

1	4	14
2	4	37

结果2.查询：

Result of 2. query:

2	8

hi lalitkr



试试这个

hi lalitkr

try this

select  count(*) count_1 
from table1 a join table2 on a.id = b.id

这篇关于sql中count（*）值的总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！