- 博客(1)
- 收藏
- 关注
原创 SQL 九九乘法表
今天同事面试新人,问了下九九乘法表怎么写。我也尝试了一下。代码: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....
2018-05-03 16:09:39 1023
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人