今天同事面试新人,问了下九九乘法表怎么写。
我也尝试了一下。
代码:
WITH t1 AS (
SELECT LEVEL AS l FROM dual CONNECT BY LEVEL <10
), t2 AS (
SELECT * FROM t1
),
t3 AS (
SELECT t1.l AS a, t2.l AS b, t1.l|| ' * '|| t2.l|| ' = '||t1.l*t2.l AS c FROM t1 , t2
WHERE t1.l <= t2.l
)
SELECT * FROM t3 PIVOT (MAX(c) FOR a IN (1,2,3,4,5,6,7,8,9))
ORDER BY b
结果: