6 messages in com.mysql.lists.win32how to find duplicated entries within...
FromSent OnAttachments
John McQuillen22 Jul 2004 17:19 
Petr Vileta22 Jul 2004 17:51 
John McQuillen22 Jul 2004 22:18 
SGr...@unimin.com23 Jul 2004 05:44 
Gerhard Brauckmann05 Aug 2004 01:50 
Cesar Vega05 Aug 2004 06:54 
Subject:how to find duplicated entries within a table?
From:Gerhard Brauckmann (gerh@gbrauckmann.de)
Date:08/05/2004 01:50:12 AM
List:com.mysql.lists.win32

Hello all,

I m trying to find duplicate entries in a specific table colum. Does anyone of you have an idea how to do this by query?

example, my data: "John", "Willi", "Martha", "John", "Mike", "Sammy", "Mike"

Now i would select ONLY the double entries in this data-table. The result should look like this:

John,John, Mike, Mike

any Idea is welcome! Thx & regards Gerhard