SQL Query to find the duplicate email

For specific employee

select * from PER_EMAIL_ADDRESSES

where PERSON_ID in (select person_id from per_all_people_f where person_number = 'XXXX')

For All employees

select * from PER_EMAIL_ADDRESSES

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Posted by : Mohammad