select '新井' qk,kjs from aa where lb='1'
union
select '老井' qk,kjs from aa where lb='2'
union
select '合计' qk,kjs from aa where lb in ('1','2')如果aa表中无数据,怎么才能显示成下表情况呢 qk kjs
新井
老井
合计
union
select '老井' qk,kjs from aa where lb='2'
union
select '合计' qk,kjs from aa where lb in ('1','2')如果aa表中无数据,怎么才能显示成下表情况呢 qk kjs
新井
老井
合计
union
select '老井' qk,nvl(kjs,'') from aa where lb='2'
union
select '合计' qk,nvl(kjs,'') from aa where lb in ('1','2')
(select '新井' qk from dual
union all
select '老井' qk from dual
union all
select '合计' qk from dual) t,
(
select '新井' qk,kjs from aa where lb='1'
union
select '老井' qk,kjs from aa where lb='2'
union
select '合计' qk,kjs from aa where lb in ('1','2')
) tt
where t.qk=tt.qk(+);