Aptean interview question

how would u show duplicate using sql