SQLで正規分布の乱数生成 #51
Description
select
-- normal distribution: box-muller
sqrt(-2 * ln(rand())) * cos(rand() * 4 * atan(1.0)) as r
from
unnest(generate_array(1, 10000)) as v {{ message }}
select
-- normal distribution: box-muller
sqrt(-2 * ln(rand())) * cos(rand() * 4 * atan(1.0)) as r
from
unnest(generate_array(1, 10000)) as v