Pregunta de entrevista de Aptean

how would u show duplicate using sql