方法1:展示成一列,使用union.
两条语句如下:
select [内容或计算] as a from [表A] where [条件]
select [内容或计算] as b from [表A] where [条件]
union语句如下:
select [内容或计算] as a from [表A] where [条件]
union
select [内容或计算] as b from [表A] where [条件]
方法2:展示成一行,使用with语句.
地址链接:https://blog.csdn.net/weixin_44535532/article/details/93974986
如何将两条SQL语句合在一起显示
最新推荐文章于 2023-11-27 09:52:16 发布