Aptean Interview Question

how would u show duplicate using sql