我想按第一个表分组,然后将第二个和第三个表的结果与已分组的计数相加...但是使用伪服务代码
select servicecode, Count(*) as count from servicerequest
where To_Char(CREATEDATE,'YYYY') = 2018
and status = 50
group by servicecode
union
select Count(*) as count from CERTREQUEST
WHERE to_char(REQDATE,'yyyy') = 2018
and service = 1
union
select Count(*) as count from LTR
WHERE to_char(REQDATE,'yyyy') = 2018
and Service = 1
只需在其他两个查询中选择它即可:
select servicecode, Count(*) as count from servicerequest
where To_Char(CREATEDATE,'YYYY') = 2018
and status = 50
group by servicecode
union
select 1, Count(*) as count from CERTREQUEST
WHERE to_char(REQDATE,'yyyy') = 2018
and service = 1
union
select 2, Count(*) as count from LTR
WHERE to_char(REQDATE,'yyyy') = 2018
and Service = 1
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句