如何将记录按操作时间的小时group by

[bingbhz]

需要统计一段时间内每个时段（小时）内的记录数，请教。

[leeboyan]

group by datepart(hour,时间字段)

[pbsql]

group by datepart(hour,操作时间)

[zicxc]

select convert(char(13),日期,120) as 小时,
count(*) as 记录数
from 你的表
where 日期 between 日期1 and 日期2
group by convert(char(13),日期,120)

[leeboyan]

select count(1) from t where ... group by datepart(hour,时间字段)

[zheninchangjiang]

select datediff(hour,@datebegin,datecolumn) as dhour,sum(...) from [table]
where datecolumn between @datebegin and @dateend group by datediff(hour,@datebegin,datecolumn)

[WangZWang]

如:
select count(1),datepart(hour,时间字段) from 表名
group by datepart(hour,时间字段)

[zicxc]

datepart(hour,操作时间)
不同天的合在一起，看你的应用了

[yesterday2000]

select count( Datepart(hour,日期)) as j from docdsp group by Datepart(hour,日期)

[lsxaa]

select datepart(hour,时间字段) as 小时,count(*) 记录数
from 表
where 时间字段>=日期1 and 时间字段<=日期2
group by datepart(hour,时间字段) order by 小时

[zlj113]

取出小时为：datename(hour,you_time)