BlackRock Interview Question

How would you select duplicate entries from a database using an SQL query?