17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE T23
(
n NUMBER(4)
);
INSERT INTO T23 VALUES(1);
INSERT INTO T23 VALUES(2);
INSERT INTO T23 VALUES(3);
INSERT INTO T23 VALUES(4);
SELECT EXP(SUM(LN(n))) FROM T23;
--测试数据
create table tb_a(id int,num int);
insert into tb_a
select 1,2 from dual union all
select 3,4 from dual;
--执行查询
Select power(10, Sum(Log(10, num))) From tb_a
--查询结果
8
关键是你要如何相乘?