Comcast Interview Question

Write an SQL query to capture duplicates from the table