sql-server - T-SQL (Azure) 计算“单元格”的内容

Question

我有一个如下表（它计算用户打开和关闭 div 的秒数）：

id | User | Seconds | DivId
1  | 1000 | 2       | 2
2  | 1000 | 125     | 2
3  | 1500 | 568     | 2
4  | 2000 | 3       | 2

我想以秒为单位计算每个用户的总秒数，所以结果应该是

User | Seconds | DivId
1000 | 127     | 2
1500 | 568     | 2
2000 | 3       | 2

我将如何计算单元格的内容？这计算条目的数量；

SELECT        
    User, COUNT (*) AS Seconds, DivId
FROM            
    dbo.AnalyticsDivTime
GROUP BY 
    User, Seconds, DivId

标签： sql-servertsqlcount

Answer 1

使用SUM代替count：

SELECT        
User, SUM(Seconds) as Seconds, DivId
FROM            
dbo.AnalyticsDivTime
GROUP BY User,  DivId