CGI Interview Question

SQL query to find duplicates.