SQL Server中时间按天分组

select Min(VisitTime),count(*) as Num from online group by datediff(day,VisitTime,getdate())
posted @ 2005-04-27 11:44  魔豆  阅读(2665)  评论(1)  编辑  收藏  举报