FROM WK_BOM T1
DB_WK T2
WHERE T1.ID = T2.ID
AND T1.REV = T2.REV
AND T1.NO ='S1234'
AND T1.KND ='FOSET'
AND NOT EXISTS (SELECT 1
FROM WK_BOM
WHERE ID = T1.ID
AND REV > T1.REV);
------------------------------------------------------
FROM (
SELECT * FROM (
SELECT BOM.*,
ROW_NUMBER() OVER(PARTITION BY ID ORDER BY ID,REV DESC ) RN
FROM WK_BOM BOM
WHERE NO='S1234'
AND KND = 'FOSET')
)
WHERE RN=1
) T1,
DB_WK T2
WHERE T1.ID = T2.ID
AND T1.REV = T2.REV ;
PK : ID, REV
마농님의 자료를 보다가 위처럼
고쳐 봤는데...데이터 일부분이 다르게 나오네요. ^^
제가 잘못한게 어디죠 ^^;
|