查询

SELECT a.id,a.item_number FROM part_master_count a WHERE EXISTS(
select ITEM_NUMBER
from part_master_count
WHERE ITEM_NUMBER=a.ITEM_NUMBER
group by ITEM_NUMBER
having count (ITEM_NUMBER) > 1

);