Query 1:
SELECT COUNT (A.EMPNO) AS [PRESENT]
FROM ERPDATA.NIITESS.DBO.ZEMP_MASXST_WEB_AL A INNER
JOIN PPA_EVENTWISEEMPLOYEEMASTER B ON
(CASE B.VC_BA WHEN '%' THEN LTRIM(RTRIM(A.PDIBUSHORT)) ELSE B.VC_BA END) = LTRIM(RTRIM(A.PDIBUSHORT))
AND (CASE B.VC_PA WHEN '%' THEN A.PA ELSE B.VC_PA END) = A.PA
WHERE A.STATUS = 3
AND A.EMPNO IN (SELECT VC_EMPCODE FROM ERPDATA.NIITESS.DBO.ADA_MXEASTER WHERE IN_ATTENDANCE_STATUS = 1 AND CH_ACTIVE = 'Y' AND VC_EMPCODE <> '')
GROUP BY B.IN_EVENTID
Query 2:
SELECT COUNT (A.EMPNO) AS [TOTAL]
FROM ERPDATA.NIITESS.DBO.ZEMP_MASXST_WEB_AL A INNER
JOIN PPA_EVENTWISEEMPLOYEEMASTER B ON
(CASE B.VC_BA WHEN '%' THEN LTRIM(RTRIM(A.PDIBUSHORT)) ELSE B.VC_BA END) = LTRIM(RTRIM(A.PDIBUSHORT))
AND (CASE B.VC_PA WHEN '%' THEN A.PA ELSE B.VC_PA END) = A.PA
WHERE A.STATUS = 3
我想将两个结果合并为两列,其中缺少列 = 查询 2 - 查询 1 以加快处理速度。我该怎么做?
例子 :
我有两个结果:
//----------------------------------------------------查询:1
1
2
3
4
//------------------------------------------------
查询:2
4
5
6
8
//------------------------------------------------结果 AS 分为两列
1 5
2 6
3 7
4 8
Select a.C1-b.C2 as Res
from
(
Select Count(*) as C1 from Users
Group by Name
) a
join
(
Select Count(*) as C2 from User2
Group by Name
) b ON 1=1 -- or desired condition if existing
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)