根据DER_DESIGN_NAME, DER_DESIGN_VERSION,INSTANCE_NAME,PARTPN 四列删除重复数据
DELETE
FROM
BOM_FUNCTIONTEMP
WHERE
id NOT IN (
SELECT
max( id )
FROM
BOM_FUNCTIONTEMP
GROUP BY
DER_DESIGN_NAME,
DER_DESIGN_VERSION,
INSTANCE_NAME,
PARTPN
)
根据DER_DESIGN_NAME, DER_DESIGN_VERSION,INSTANCE_NAME,PARTPN 四列删除重复数据
DELETE
FROM
BOM_FUNCTIONTEMP
WHERE
id NOT IN (
SELECT
max( id )
FROM
BOM_FUNCTIONTEMP
GROUP BY
DER_DESIGN_NAME,
DER_DESIGN_VERSION,
INSTANCE_NAME,
PARTPN
)