34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT a ,
COUNT(DISTINCT bc) AS cnt
FROM ( SELECT a ,
CONVERT(VARCHAR, b) +'|'+ CONVERT(VARCHAR, c) AS bc --加个不常出现的字符
FROM TB
) T
GROUP BY a
SELECT a ,
COUNT(DISTINCT bc) AS cnt
FROM ( SELECT a ,
CONVERT(VARCHAR, b) + CONVERT(VARCHAR, c) AS bc
FROM TB
) T
GROUP BY a
/*
a cnt
0 3
1 3*/