Pergunta de entrevista da empresa Amdocs

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