我想查出字段BadContent里各个值出现的次数,写这样的语句却提示不对数据表sysWebTbid OQCTime BadContent
1 2012-1-2 上网2 2012-1-6 逃课3 2012-1-6 逃课
4 2012-26 上网
要得到的结果BadContent BNO
上网 2逃课 2
1 2012-1-2 上网2 2012-1-6 逃课3 2012-1-6 逃课
4 2012-26 上网
要得到的结果BadContent BNO
上网 2逃课 2
from sysWebTb
group by BadContent
from sysWebTb
group by BadContent
from tb
group by BadContent
from sysWebTb
group by BadContent
select BadContent,count(1) [BNO]
from syswebtb
group by BadContent
from sysWebTb
group by BadContent
from sysWebTb
group by BadContent楼主可以结贴了。
GOCREATE TABLE sysWebTb
(
id INT
, OQCTime DATETIME
, BadContent VARCHAR(20)
)BEGIN
INSERT INTO sysWebTb
SELECT 1,'2012-1-2','上网'
UNION ALL
SELECT 2,'2012-1-6','逃课'
UNION ALL
SELECT 3,'2012-1-6','逃课'
UNION ALL
SELECT 4,'2012-1-26','上网'
END;SELECT BadContent,BND=COUNT(1)
FROM sysWebTb
GROUP BY BadContent结果:
BanContent BND
上网 2
逃课 2