Equilend interview question

How do you find duplicates in SQL? How do you count unique values?