create table myTab(
myBool number(1),
myPro varchar2(10)
)
insert into myTab values(1,'a');
insert into myTab values(1,'b');
insert into myTab values(0,'c');
insert into myTab values(1,'d');
insert into myTab values(0,'c');
insert into myTab values(1,'b');
insert into myTab values(0,'b');
insert into myTab values(1,'d');
insert into myTab values(1,'b');
insert into myTab values(0,'b');
insert into myTab values(0,'c');select myPro,sum(decode(myBool ,'0',1,'1','1'))Bo0lall , sum(decode(myBool ,'0',1)) Bool0,sum(decode(myBool ,'1',1)) Bool1
from myTab group by myPro;
我刚学会,练练,呵呵
myBool number(1),
myPro varchar2(10)
)
insert into myTab values(1,'a');
insert into myTab values(1,'b');
insert into myTab values(0,'c');
insert into myTab values(1,'d');
insert into myTab values(0,'c');
insert into myTab values(1,'b');
insert into myTab values(0,'b');
insert into myTab values(1,'d');
insert into myTab values(1,'b');
insert into myTab values(0,'b');
insert into myTab values(0,'c');select myPro,sum(decode(myBool ,'0',1,'1','1'))Bo0lall , sum(decode(myBool ,'0',1)) Bool0,sum(decode(myBool ,'1',1)) Bool1
from myTab group by myPro;
我刚学会,练练,呵呵
where a.myPro=b.myPro and a.myBool=0 and b.myBool=1
group by a.myPro
select myPro,sum(decode(myBool ,'0',1,'1','1'))Bo0lall , sum(decode(myBool ,'0',1,0)) Bool0,sum(decode(myBool ,'1',1,0)) Bool1
from myTab group by myPro;