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'