通过下面语句统计一个中间结果,然后再统计具体项目select deptname,riskname,year,risktype from(
(SELECT deptname,riskname,to_char(creationtime,'yyyy') year,'保持' risktype from dept
intersect
SELECT deptname,riskname,to_char(add_months(creationtime,12),'yyyy') year,'保持' risktype from dept)
union all
(SELECT deptname,riskname,to_char(creationtime,'yyyy') year,'新增' risktype from dept
minus
SELECT deptname,riskname,to_char(add_months(creationtime,12),'yyyy') year,'新增' risktype from dept)
union all
(SELECT deptname,riskname,to_char(add_months(creationtime,12),'yyyy') year,'减少' risktype from dept
minus
SELECT deptname,riskname,to_char(creationtime,'yyyy') year,'减少' risktype from dept)
)
(SELECT deptname,riskname,to_char(creationtime,'yyyy') year,'保持' risktype from dept
intersect
SELECT deptname,riskname,to_char(add_months(creationtime,12),'yyyy') year,'保持' risktype from dept)
union all
(SELECT deptname,riskname,to_char(creationtime,'yyyy') year,'新增' risktype from dept
minus
SELECT deptname,riskname,to_char(add_months(creationtime,12),'yyyy') year,'新增' risktype from dept)
union all
(SELECT deptname,riskname,to_char(add_months(creationtime,12),'yyyy') year,'减少' risktype from dept
minus
SELECT deptname,riskname,to_char(creationtime,'yyyy') year,'减少' risktype from dept)
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货