Question d’entretien chez Amdocs

How to find duplicate data in sql? What is SCD type 2?