Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


How can I select duplicate rows in MySQL

peterv6peterv6 Member Posts: 18
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!
Sign In or Register to comment.