HeyJobs interview question

How to find duplicates in a table using SQL