用SQL/Python输出九九乘法表

  忙的时候忙死  闲的时候闲得蛋疼  闲着无聊看看书，发现很多简单但有意思的SQL，记录一下：

WITH X1 AS
(SELECT LEVEL LV FROM DUAL CONNECT BY  LEVEL <= 9) --序列
,X2 AS (
SELECT A.LV LV_A
       ,B.LV LV_B
       ,A.LV||' x '||B.LV||' = '||RPAD((A.LV*B.LV),2,' ') TEXT
 FROM X1 A
 JOIN X1 B ON A.LV <= B.LV
 ) --构造基础数据
SELECT LISTAGG(X2.TEXT,' ') WITHIN GROUP(ORDER BY X2.LV_A) AS "小九九"
FROM X2
GROUP BY X2.LV_B --分类汇总

很简单的SQL，特殊一点的是用到了listagg函数。

 

----2019-09-11---------

一直单纯写SQL，颇感无聊，学一点Python。下面用Python输出九九乘法表，比SQL容易多了：

for i in range(1,10):
    for j in range(1,i+1):
            print('{} x {} = {}'.format(i,j,i*j),end = '   ')
    print()