搜索
您的当前位置:首页正文

SqlServer按小时进行分组统计

2020-11-09 来源:知库网

SqlServer 无 SELECT DATEADD(hh,DATEDIFF(hh,0,Date),0) [Hour] FROM [t1] group by DATEDIFF(hh,0,Date)

Sql Server <无> $velocityCount-->
SELECT DATEADD(hh,DATEDIFF(hh,0,Date),0) [Hour]
 FROM [t1] 
 group by DATEDIFF(hh,0,Date)
Top