34,837
社区成员




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*/