SELECT ITEMID, BOMID, ROW_NUMBER() OVER(PARTITION BY ITEMID ORDER BY RECID DESC) RN FROM BOMVERSION
WHERE BOMVERSION.DATAAREAID='***'
需求:
执行后结果样子:
Item001 | BOM_V3 | 1 |
Item001 | BOM_V2 | 2 |
Item001 | BOM_V1 | 3 |
Item002 | BOM_V2 | 1 |
Item002 | BOM_V1 | 2 |
SELECT ITEMID, BOMID, ROW_NUMBER() OVER(PARTITION BY ITEMID ORDER BY RECID DESC) RN FROM BOMVERSION
WHERE BOMVERSION.DATAAREAID='***'
需求:
执行后结果样子:
Item001 | BOM_V3 | 1 |
Item001 | BOM_V2 | 2 |
Item001 | BOM_V1 | 3 |
Item002 | BOM_V2 | 1 |
Item002 | BOM_V1 | 2 |