耀登

同步基础

计划

11

22

33


44

55


66

77

88

去掉其他工单保留5个

 where [LOT_ID] not in (


SELECT [LOT_ID]
FROM (
SELECT *,
        ROW_NUMBER() OVER (PARTITION BY [PRODUCT_ID] ORDER BY [PRODUCT_ID]) AS rn
FROM [Udit.SFC].[dbo].[QS_LOTS]
WHERE [PRODUCT_ID] IN (SELECT [PRODUCT_ID]  FROM [Udit.SFC].[dbo].[QS_PRODUCTS]  where name in ('B91201-00','A22124-30','A22232-30','A22439-00','A91859-00 ','B11278-00'))
) AS subquery
WHERE rn <= 5
)