求和语句:
select mobname,sum(zc),sum(yyt2),sum(yyt3), sum(zc)+sum(yyt2)+sum(yyt3) from goodssale select mobname,sum(zc),sum(yyt2),sum(yyt3), sum(zc)+sum(yyt2)+sum(yyt3) from goodssale group by mobname
怎么的不到结果呢???
select mobname,sum(zc),sum(yyt2),sum(yyt3), sum(zc)+sum(yyt2)+sum(yyt3) from goodssale select mobname,sum(zc),sum(yyt2),sum(yyt3), sum(zc)+sum(yyt2)+sum(yyt3) from goodssale group by mobname
怎么的不到结果呢???
select mobname,sum(1),sum(2),sum(3), ),sum(4),..,(20),sum(1)+sum(2)+sum(3)+..+sum(20) from goodssale group by mobname
前面的sum都得了,就是最后一个没有结果,这么回事呢??
select mobname,nvl(sum(1),0),nvl(sum(2),0),nvl(sum(3),0),nvl(sum(4),0),..,(20),nvl(sum(1),0)+nvl(sum(2),0)+nvl(sum(3),0)+..+nvl(sum(20),0) from goodssale group by mobname