展开全部
CREATE TABLE info (
users varchar(100)
);
INSERT INTO info VALUES('userA@userB@userC');
INSERT INTO info VALUES('userB@userC@userD');
INSERT INTO info VALUES('userC@userD@userE');
COLUMN "用户32313133353236313431303231363533e59b9ee7ad9431333335303532" FORMAT A15
SELECT
to_char(strvalue) as "用户",
count(*) AS "用户数"
FROM
info,
table(fn_split( info.users, '@'))
GROUP BY
to_char(strvalue)
ORDER BY
1;
用户 用户数
--------------- ----------
userA 1
userB 2
userC 3
userD 2
userE 1
上面这样的效果, 是否满足你的需求?
如果满足的话, 你再往下看&#