我的查询中的COUNT操作 [英] COUNT operation in my query

问题描述

我将此查询应用于我在SQL服务器中的数据，用于计算最大和最小日期组之间的差异有些ID，我的查询如下

i applied this query over my data in SQL server for calculating difference between max and min date group by Some id, my query is as follows

SELECT COUNT(DIFF)
MaxDate,
MinDate,
DATEDIFF(D, MinDate, MaxDate)/30 AS DIFF
FROM (
SELECT
   MAX(TDate) AS MaxDate,
   MIN(TDate) AS MinDate
   FROM EDATA
   GROUP BY TCard
)a

此查询生成结果为

This query is producing result as

DIFF
10
5
10
10
5
7

现在我想对此应用计数操作来计算特定差异的发生情况

Now i want to apply count operation over this to calculate occurring of particular difference as

Count
3
2
1

我想知道如何在我的查询中对上面提到的特定功能应用计数操作（对于计数）

I want to know how to apply count operation over my query for that particular functionality, mentioned above(for count)

推荐答案

您好，



查看此查询：

Hi,

Check this Query :

SELECT 
--COUNT(DIFF)
Count(DATEDIFF(D, MinDate, MaxDate)/30) AS DIFF

FROM (
SELECT

   MAX(TDate) AS MaxDate,
   MIN(TDate) AS MinDate
   FROM EDATA
   GROUP BY TCard
)a
Group by DATEDIFF(D, MinDate, MaxDate)/30

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