SQL按小时统计
时间：2011-05-19 来源：Paste
select convert(varchar(13),date,120) as date,sum(usercount) from
[OnLinePeoples] group by convert(varchar(13),date,120)
相关阅读 更多 +
时间：2011-05-19 来源：Paste
select convert(varchar(13),date,120) as date,sum(usercount) from
[OnLinePeoples] group by convert(varchar(13),date,120)
