662
社区成员




SELECT COUNT(1)-- 耗费 5950 ,用时3.721s/2.781s/4.562s
FROM table1 A
WHERE A.JOB_CODE IS NOT NULL
AND EXISTS (SELECT 1 FROM table2 B WHERE B.FACTDETAILNO = '5005' AND A.JOB_CODE LIKE A.JOB_CODE+'%')
SELECT COUNT(1)-- 耗费 5950 ,用时3.721s/2.781s/4.562s
FROM table1 A
WHERE A.JOB_CODE IS NOT NULL
AND EXISTS (SELECT 1 FROM table2 B AND B.FACTDETAILNO = '5005' WHERE A.JOB_CODE LIKE A.JOB_CODE+'%')