22,209
社区成员
发帖
与我相关
我的任务
分享
CONVERT(VARCHAR(10),createdate,120) AS 日期 ,
DATEPART(hh,createdate) AS 小时,COUNT(*)AS 记录
FROM transactionlog
where CreateDate>=@date1+' 00:00:00' and createdate<=@date2+' 23:59:59'
GROUP BY CONVERT(VARCHAR(10),createdate,120),DATEPART(hh,createdate),
DATEPART(mi,createdate)/30--再加一个group组
order by 小时