Equilend Interview Question

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