sql使用case when实现九九乘法表

最新推荐文章于 2023-04-11 11:35:07 发布

打我长痘痘

最新推荐文章于 2023-04-11 11:35:07 发布

阅读量539

点赞数 1

分类专栏： sql 文章标签：数据库

本文链接：https://blog.csdn.net/qq_44449767/article/details/106019570

版权

sql 专栏收录该内容

10 篇文章 2 订阅

订阅专栏

代码块

select
(case when a < 1 then '' else  Concat('1*',a,'=',1*A)    end)   as   "[1]",
(case when a < 2 then '' else Concat('2*',a,'=',2*A)    end)   as   "[2]",
(case when a < 3 then '' else Concat('3*',a,'=',3*A)    end)   as   "[3]",
(case when a < 4 then '' else Concat('4*',a,'=',4*A)    end)   as   "[4]",
(case when a < 5 then '' else Concat('5*',a,'=',5*A)    end)   as   "[5]",
(case when a < 6 then ''else  Concat('6*',a,'=',6*A)    end)   as   "[6]",
(case when a < 7 then ''else  Concat('7*',a,'=',7*A)    end)   as   "[7]",
(case when a < 8 then ''else  Concat('8*',a,'=',8*A)    end)   as   "[8]",
(case when a < 9 then ''else  Concat('9*',a,'=',9*A)    end)   as   "[9]"
from   (
select   1   as   a
union   all
select   2
union   all
select   3
union   all
select   4
union   all
select   5
union   all
select   6
union   all
select   7
union   all
select   8
union   all
select   9
)   as   t1;