SQL Query for finding duplicates

How do you find duplicate records using SQL?

select name, count(name) as Occurrences
  from members
  group by name having (count(name)>1)

And ofcourse, to get records that occur only once, use count(name) = 1 instead.