2-3-14 階乗を求めるその1

SQLパズル

5の階乗を求める。

SQL

select round(exp(sum(Ln(Val)))) as "5の階乗"
from (select 1 as Val from dual
union select 2 as Val from dual
union select 3 as Val from dual
union select 4 as Val from dual
union select 5 as Val from dual);

解説

対数を使って、掛け算を足し算にして、階乗を計算してます。

---

対数の資料

---