oracal来源不同表的结果集合并
select kinds,count(1) as cl from t_b_current_alarm group by kinds union all select 'sj' kinds, count(*) as cl from T_B_TROUBLEWORK t where t.status like '%处理中%'
常量放在前面是确定好他的值
kinds cl
aqgj 1
wlgj
原创
2017-04-17 15:13:27 ·
321 阅读 ·
0 评论