SqlServer按小时进行分组统计

来源：学车网

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)

显示全文