SELECT data, count(*)
FROM `table1`
group by data
having count(*) > 1
César
>From: "Gerhard Brauckmann" <gerhard@stripped>
>To: "'MySQL Win32 List'" <win32@stripped>
>Subject: how to find duplicated entries within a table?
>Date: Thu, 5 Aug 2004 10:50:34 +0200
>
>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
>
>
>--
>MySQL Windows Mailing List
>For list archives: http://lists.mysql.com/win32
>To unsubscribe: http://lists.mysql.com/win32?unsub=1
>
_________________________________________________________________
Las mejores tiendas, los precios mas bajos, entregas en todo el mundo,
YupiMSN Compras: http://latam.msn.com/compras/
