今天剛剛學到，貼上來留作資料
--測試數據
create table t(id int,qty int);
insert into t
select 1,2 from dual union all
select 2,4 from dual union all
select 3,6 from dual union all
select 4,5 from dual;
--執行查詢
Select power(10, Sum(Log(10, qty))) From t
--查詢結果
240
