SQL Server中时间按天分组

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