答案:select exp(sum(log(a.number))) from table a;
思路:
1.首先努力回忆你初中学的子数 exp()和对数log() 函数,你就会知道
对数的运算法则:
1、log(a) (M·N)=log(a) M+log(a) N
2、log(a) (M÷N)=log(a) M-log(a) N
3、log(a) M^n=nlog(a) M
4、log(a)b*log(b)a=1
5、log(a) b=log (c) b÷log (c) a
指数的运算法则:
1、[a^m]×[a^n]=a^(m+n) 【同底数幂相乘,底数不变,指数相加】
2、[a^m]÷[a^n]=a^(m-n) 【同底数幂相除,底数不变,指数相减】
3、[a^m]^n=a^(mn) 【幂的乘方,底数不变,指数相乘】
4、[ab]^m=(a^m)×(a^m) 【积的乘方,等于各个因式分别乘方,再把所得的幂相乘】
推断过程:
因为 sum(log(a.number)) = log(a.number1) + log(a.number2) +log(a.number3)+.....
所以 exp(sum(log(a.number))) = exp( (log(a.number1) + log(a.number2) +log(a.number3)+.....))
=exp(log(a.number1) )*exp(log(a.number2) )*exp(log(a.number3) )*.....
=a.number1*a.number2*a.number3