How can I select duplicate rows in MySQL - Programmers Heaven

Howdy, Stranger!

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

Categories

How can I select duplicate rows in MySQL

I need to select all the duplicate rows in a MySQL table. The table contains 3 columns:

ID - unique primary key
Name
Description

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
...etc

Any help would be greatly appreciated. I'm new to this, so be kind!
Sign In or Register to comment.