进销存软件版1楼: SELECT COUNT(registrar) AS Expr1
FROM serono
GROUP BY registrar
HAVING (CONVERT(char(8), redata, 112) = ＇＇20060316＇＇)

2楼: SELECT COUNT(registrar) AS Expr1
FROM serono
GROUP BY registrar,redata
HAVING (CONVERT(char(8), redata, 112) = ＇＇20060316＇＇) 如汽车进销存

3楼: 我是要按20060316这一天的registrar分组

4楼: SELECT COUNT(registrar) AS Expr1
FROM serono
where (CONVERT(char(8), Max(redata), 112) = ＇＇20060316＇＇)
GROUP BY registrar


你能保证按registrar

5楼: 来自：dnoopy, 时间：2006-3-17 14:05:59, ID：3385206
SELECT COUNT(registrar) AS Expr1
FROM serono
where (CONVERT(char(8), Max(redata), 112) = ＇＇20060316＇＇)
GROUP BY registrar
这一个语句是错的
SQL语言中设定集合函数的查询条件时使用HAVING从句而不是WHERE从句。通常情况下，HAVING从句被放置在SQL命令的结尾处

6楼: 該SQL命令錯誤, group by 的Field必須位於 select 中

SELECT registrar, COUNT(*) AS Expr1
FROM serono
where (CONVERT(char(8), Max(redata), 112) = ＇＇20060316＇＇)
GROUP BY registrar

进销存软件版7楼: 不好意思，错了，本来想用集合函数，后来发现不用，就直接粘上去了，没注意。
SELECT COUNT(registrar) AS Expr1
FROM serono
where (CONVERT(char(8), redata, 112) = ＇＇20060316＇＇)
GROUP BY registrar

8楼: 接受答案了.