[求助]关于所有记录中的字符统计

coolbug

某表中某列内容如下，请教如何统计所有记录中A,B,C等各自出现的次数，原来采用循环语句将所有记录读出并连接成字符串，再计算字符出现次数，但感觉这个法子挺笨，并且当记录量很大时不好处理，各位是否有更好多法子，谢谢。

AB

BCS

CDR

AD

ACC

FG

[此贴子已经被作者于2006-12-1 13:47:57编辑过]

csp820

此问题有代表性，我也想知道答案，恳请高手赐教！

wwwwa

TRY：建立临时表，内容为A-Z，你可以更改成你的数据，假设字段最大容量为3个字符，你可以更改，思路是这样，SQL语句：

SELECT B1,SUM(JS) FROM (
SELECT A.B1,COUNT(*) AS JS FROM (
SELECT mid(bh,1,1) AS b1, nz(mid(bh,2,1),'') AS b2, nz(mid(bh,3,1),'') AS b3, *
FROM a41) A
LEFT JOIN ZMB B ON A.B1=B.ZM GROUP BY A.B1
UNION ALL SELECT A.B2,COUNT(*) AS JS FROM (
SELECT mid(bh,1,1) AS b1, nz(mid(bh,2,1),'') AS b2, nz(mid(bh,3,1),'') AS b3, *
FROM a41) A
LEFT JOIN ZMB B ON A.B2=B.ZM GROUP BY A.B2
UNION ALL SELECT A.B3,COUNT(*) AS JS FROM (
SELECT mid(bh,1,1) AS b1, nz(mid(bh,2,1),'') AS b2, nz(mid(bh,3,1),'') AS b3, *
FROM a41) A
LEFT JOIN ZMB B ON A.B3=B.ZM GROUP BY A.B3) WHERE B1<>' ' GROUP BY B1

hi-wzj

http://www.office-cn.net/Article/ShowArticle.asp?ArticleID=500