As shown in figure.

The result has been query out.
Now need to use the results of all PASS_RATE multiplication, then get a result
Could you tell me how to write again?
Or what function?

Mean is 99.95 * 99.98 * 100 * 100 * 100...

CodePudding user response:

Logarithmic and exponential function can use mathematics method to add:
Select the power (10, the sum (log (100), 10 PASS_RATE/)) from Tbname;

CodePudding user response:

The SELECT EXP (SUM (LN (replace (pass_rate, '%', ')))) FROM A

CodePudding user response:

@ wit, how are you, how to contact you, I ask you

CodePudding user response:

My phone, 13382339993

CodePudding user response:

If it is all multiplicative, use the method of the second floor is ok. But the second floor of the replace needn't
If it is to classify multiplicative, needs analysis function, such as
The select exp (sum (ln (pass_rate)) over (partition by model_name))

CodePudding user response:

But if you use the ln method, pass_rate cannot be negative, or complains

CodePudding user response:

Learn
Using the SUM between + LN addition is equivalent to multiplication in the form of parameters, then in with EXP solve multiplication numerical, cow force cow force

CodePudding user response:

Was my idea is through the listagg all data splicing together, and then write a custom function cycle is multiplied by the results come out, this way is EXP (SUM (LN (XXX))) for the burst well

CodePudding user response:

Learn
Using the SUM between + LN addition is equivalent to multiplication in the form of parameters, then in with EXP solve multiplication number, cow force