Amdocs interview question

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