sql 语句:如何求每天的记录条数.

[dwh0722]

我现在要对一个新闻表进行统计,要求得到每天上的新闻条数.

如:
id title addtime
150 1111 2004-5-27 10:26:39
151 2222 2004-5-27 10:44:39
152 1133 2004-6-27 10:26:39

SELECT COUNT(id) AS Expr1
FROM news
GROUP BY AddTime
是得不到每天得总条数的,我该这么做? (注意,我要的是每天的,就是希望GROUP BY AddTime 的addtime不要小时分秒,是短时间)

[dwh0722]

我查到了
SELECT COUNT(id) AS Expr1
FROM news
GROUP BY
CONVERT(varchar, AddTime, 111)
大家进来吧,我好结贴

[Bmonkey]

学习

[frankwong]

SELECT CONVERT(varchar(10), AddTime, 120) as 日期,COUNT(id) AS 记录数量
FROM news
GROUP BY CONVERT(varchar(10), AddTime, 120)

[YiOnLine]

哈哈.

[pressman]

哈哈.

[ksbsoft]

SELECT CONVERT(varchar(10), AddTime, 120) as 日期,COUNT(id) AS 记录数量
FROM news
GROUP BY CONVERT(varchar(10), AddTime, 120)