oracle关联查询union all 讲解

最新推荐文章于 2024-06-10 19:02:00 发布

许海洋

最新推荐文章于 2024-06-10 19:02:00 发布

阅读量1.4k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/qq_16557323/article/details/52384954

版权

数据库专栏收录该内容

16 篇文章 1 订阅

订阅专栏

1、SELECT t.recid,t.szdq1,t.szdq2,t.f_nb_zjly_fsgzl1,t.f_nb_zjly_fsgzl2 FROM B_JH_ZIJLY T where t.szdq1 is NOT NULL

2、select t.recid as recid,t.szdq1 as szdq,t.f_nb_zjly_fsgzl1 as f_nb_zjly_fsgzl from B_JH_ZIJLY T where t.recid = '123DC7C4FA95E76BD9F76E16079B4F43'
union all
select t.recid as recid,t.szdq2 as szdq,t.f_nb_zjly_fsgzl2 as f_nb_zjly_fsgzl from B_JH_ZIJLY T where t.recid = '123DC7C4FA95E76BD9F76E16079B4F43'

3、select t.szdq1 as szdq,t.f_nb_zjly_fsgzl1 as f_nb_zjly_fsgzl from B_JH_ZIJLY T where t.recid = '123DC7C4FA95E76BD9F76E16079B4F43'
union all
select t.szdq2 as szdq,t.f_nb_zjly_fsgzl2 as f_nb_zjly_fsgzl from B_JH_ZIJLY T where t.recid = '123DC7C4FA95E76BD9F76E16079B4F43'