首先将数据规范,比如 update SUBJECTINFO set SUBJECTNAME ='其它' where SUBJECTNO='10103'然后再 select SUBJECTNO,SUBJECTNAME,sum(MONEY) from SUBJECTINFO group by SUBJECTNO,SUBJECTNAME要不SUBJECTNO对应多个SUBJECTNAME,电脑也不知道取哪个
select SUBJECTNO,decode(SUBJECTNO,10101 ,'现金' ,10102 ,'支票' ,'其它'),sum(MONEY) from SUBJECTINFO group by SUBJECTNO
select distinct T1.SUBJECTNO, T2.SUBJECTNAME, T1.sm from (select SUBJECTNO,sum(money) sm from SUBJECTINFO group by SUBJECTNO) T1, (select distinct SUBJECTNO,SUBJECTNAME from SUBJECTINFO ) T2 where T1.SUBJECTNO=T2.SUBJECTNO;
最简单的方法就是另建一个表:(subjectno,sujectname)
select SUBJECTNO,max(SUBJECTNAME) as SUBJECTNAME,sum(MONEY) from SUBJECTINFO group by SUBJECTNO
select SUBJECTNO,max(decode(SUBJECTNAME,'其他',其它)),sum(MONEY) from UBJECTINFO group by SUBJECTNO
就是用这个方法吧 感觉还不错 : Ranma_True(乱马1/2(真)) ( ) 信誉:100 select SUBJECTNO,max(SUBJECTNAME) as SUBJECTNAME,sum(MONEY) from SUBJECTINFO group by SUBJECTNO
update SUBJECTINFO set SUBJECTNAME ='其它' where SUBJECTNO='10103'然后再
select SUBJECTNO,SUBJECTNAME,sum(MONEY) from SUBJECTINFO
group by SUBJECTNO,SUBJECTNAME要不SUBJECTNO对应多个SUBJECTNAME,电脑也不知道取哪个
group by SUBJECTNO
from (select SUBJECTNO,sum(money) sm from SUBJECTINFO group by SUBJECTNO) T1,
(select distinct SUBJECTNO,SUBJECTNAME from SUBJECTINFO ) T2
where T1.SUBJECTNO=T2.SUBJECTNO;
group by SUBJECTNO
group by SUBJECTNO
select SUBJECTNO,max(SUBJECTNAME) as SUBJECTNAME,sum(MONEY) from SUBJECTINFO
group by SUBJECTNO