附加的图像表示我的SQL数据表。我正在尝试创建两个新列,这两个列包含总分钟数和每天每个不同案例的服务计数。例如,如果一个案例编号出现三次,这意味着提供了三项服务,但我希望每天和每个案例编号的总分钟数和服务总数分别计算。我尝试了下面的查询,它给出了服务的计数,但不是每天有多少服务,也不是总分钟数。
SELECT *,
COUNT(CASE_NUM) OVER (PARTITION BY CASE_NUM) as AGGRE_SERVICES,
SUM(TOTAL_MIN) OVER (PARTITION BY DATE) as AGGRE_MINS
FROM #SQLTABLE发布于 2016-09-09 05:58:50
尝试下面的代码。
SELECT *,
COUNT(CASE_NUM) OVER (PARTITION BY CASE_NUM, DATE) as AGGRE_SERVICES,
SUM(TOTAL_MIN) OVER (PARTITION BY CASE_NUM, DATE) as AGGRE_MINS
FROM #SQLTABLEhttps://stackoverflow.com/questions/39399927
复制相似问题