Find Duplicate Fields in a table

select field1,field2,field3, count(*)
  from table_name
  group by field1,field2,field3
  having count(*) > 1