SELECT foobar, COUNT(foobar) AS NumOfFoos FROM bar GROUP BY foobar HAVING ( COUNT(foobar) > 1 )
On 2/6/07, Tomás Abad Fernández <[EMAIL PROTECTED]> wrote:
Any can tell me a slq to find duplicate entries in a table? Thanks, Tomás
-- Lars Schwarz Gottorpstrasse 20 26122 Oldenburg T 0441 2171 354 0 F 0441 2171 354 0 M 0179 512 4628 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
