取值范围确定了就简单多了
select A||B||C,COUNT(1)
FROM(
select col1,
max(decode(col2,'a',col2)) as A,
max(decode(col2,'b',col2)) as B,
max(decode(col2,'c',col2)) as C
from test
group by col1
)GROUP BY A,B,C
select A||B||C,COUNT(1)
FROM(
select col1,
max(decode(col2,'a',col2)) as A,
max(decode(col2,'b',col2)) as B,
max(decode(col2,'c',col2)) as C
from test
group by col1
)GROUP BY A,B,C
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货