`

一条sql求N阶乘

SQL 
阅读更多
-- 根据公式:log(a)(MN)=log(a)(M)+log(a)(N)
SQL> SELECT POWER(10, SUM(LOG(10, LEVEL)))
  2    FROM DUAL
  3  CONNECT BY LEVEL <= 6;

POWER(10,SUM(LOG(10,LEVEL)))
----------------------------
                         720
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics