sql 多列重复

select id from (
SELECT row_number() OVER (PARTITION BY m.code,m.company_id ORDER BY m.code) g_index,m.code,m.COMPANY_ID,m.id FROM bom_part m,(
SELECT code,COMPANY_ID
FROM bom_part
GROUP BY code,COMPANY_ID
HAVING COUNT(1)>1

) AS m1
WHERE m.code=m1.code AND m.COMPANY_ID=m1.COMPANY_ID)t