Cacher is the code snippet organizer for pro developers

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