Pregunta de entrevista de Amdocs

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