有个字段有4种标识如下:
字段名: select_bank
标识: 1,11,2,22
想要的结果,一下统计出选1或是先11,或是选2,或是选22的数据人数有多少.
sum(decode(select_bank,?,?,?))这个地方的表达式怎么写的,请高手赐教,谢谢
字段名: select_bank
标识: 1,11,2,22
想要的结果,一下统计出选1或是先11,或是选2,或是选22的数据人数有多少.
sum(decode(select_bank,?,?,?))这个地方的表达式怎么写的,请高手赐教,谢谢
sum(decode(select_bank,11,1,0))
sum(decode(select_bank,1,人数,0)) 标识1,
sum(decode(select_bank,11,人数,0)) 标识11,
sum(decode(select_bank,2,人数,0)) 标识2,
sum(decode(select_bank,22,人数,0)) 标识22
from table
group by ....
select 11 as f from dual union
select 2 from dual union
select 22 from dual)
group by decode(f,11,1,f)