Oracle删除重复数据

根据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 
	)