外套一层 select
比如 SELECT SUM(COUNT_) SUM_ FROM (
你原来的SQL
) A
--------------
SELECT SUM(COUNT_) [SUM_] FROM (
SELCET 字段1,COUNT(字段2) [COUNT_] FROM 表 GROUP BY 字段1
) A
---------
SELECT T.year_,SUM(T.COUNT_) [SUM_],T.NAME FROM(
SELECT TO_CHAR(RQ,'YYYY')as year_,count(A.MC) [COUNT_],B.NAME FROM PROJECT A LEFT JOIN PROJECT_CLASS B ON A.XZ=B.ID WHERE RQ >= SYSDATE - INTERVAL '4' YEAR AND (B.NAME = '老师' OR B.NAME = '学生') group by B.NAME,TO_CHAR(RQ,'YYYY')
) T GROUP BY T.year_,T.NAME
union all
SELECT TO_CHAR(RQ,'YYYY')as year_,count(A.MC) [COUNT_],B.NAME FROM PROJECT A LEFT JOIN PROJECT_CLASS B ON A.XZ=B.ID WHERE RQ >= SYSDATE - INTERVAL '4' YEAR AND (B.NAME = '老师' OR B.NAME = '学生') group by B.NAME,TO_CHAR(RQ,'YYYY')
1min目标场景问卷
立即参与
