以前一直好奇,oracle中提供sum函数,为什么没有multiply函数呢?原来可以这样写的:
select sum(id)"和",power(10,sum(log(10,t.id )))"乘积" from
(
select 1 id from dual
union
select 2 id from dual
union
select 3 id from dual
union
select 7 id from dual
) t;
select sum(t.value) "和" ,power(10,sum(log(10,t.value)))"乘积"
from
( select 3 id , 4 value from dual
union
select 1 id , 1 value from dual
union
select 1 id , 2 value from dual
union
select 2 id , 3 value from dual
union
select 2 id , 4 value from dual
)t
group by id