利用count和decode可以根据类别来统计数据,比如甲、乙、丙三种,统计三种类别的总量,可以使用
select count(decode(value,'甲',1)) as A,
count(decode(value,'乙',1)) as B,
count(decode(value,'丙',1)) as C from dual
利用count和decode可以根据类别来统计数据,比如甲、乙、丙三种,统计三种类别的总量,可以使用
select count(decode(value,'甲',1)) as A,
count(decode(value,'乙',1)) as B,
count(decode(value,'丙',1)) as C from dual