SELECT id_card_number, COUNT(*) occurrences FROM hr_person_master GROUP BY id_card_number HAVING COUNT(*) > 1;
Comments 0