I need to select all the duplicate rows in a MySQL table. The table contains 3 columns:
ID - unique primary key
I want to select all records with duplicate values in the name field, so the output would be like:
1 Bill operations
4 Bill receiving
7 Tom operations
8 Tom customer service
Any help would be greatly appreciated. I'm new to this, so be kind!