Check for Duplicate Row using Group By function This script deletes each row in the group after the first row.…