select exp(sum(ln( field_name ))) from table_name; 引用
有的 把几个函数函数整合一下 得出的结果最后round一下。、
select exp(ln(1)+ln(2)+ln(6)) from dual;
早就有关于累乘的讨论了 楼主百度一下:oracle 累乘 有你想要的
--测试数据 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
实测成功: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; 结果为:24
直接 select a*b from tb;
引用
楼主百度一下:oracle 累乘
有你想要的
--测试数据
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
(
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;
结果为:24