SELECT (SELECT COUNT(*) AS COUNTNUM
FROM POORDR T
WHERE T.VENDOR_NO IN ('99025', '99003', '99056')) AS INTERNAL,
(SELECT COUNT(*) AS STNUM
FROM POORDR ST
WHERE ST.VENDOR_NO NOT IN ('99025', '99003', '99056')) AS OFFJT
FROM DUAL

SELECT (SELECT COUNT(*) AS COUNTNUM
FROM (SELECT T1.VENDOR_NO
FROM POORDR T1
WHERE T1.PO_NO BETWEEN '044927' AND '044944') T
WHERE T.VENDOR_NO IN ('99025', '99003', '99056')) AS INTERNAL,
(SELECT COUNT(*) AS STNUM
FROM (SELECT T2.VENDOR_NO
FROM POORDR T2
WHERE T2.PO_NO BETWEEN '044927' AND '044944') ST
WHERE ST.VENDOR_NO NOT IN ('99025', '99003', '99056')) AS OFFJT
FROM DUAL

CKA,CKS双认证,有多年kubernetes一线经验。
某知名企业高级DevOps工程师,K8s运维架构师,Linux集群架构专家。