SELECT foobar,
****(foobar) AS NFoos
FRM bar
GRUP BY foobar
HAVING ( ****(foobar) 1 )
2/6/07, T Abad F <informatica (AT) vipventa (DOT) comwrote:
Any can tell me a slq to find duplicate entries in a table?
>
>
>
Thanks,
T
--

That actually should be
HAVING ( NFoos 1 )

Message
From: "Lars Schwarz" <lars.schwarz (AT) gmail (DOT) com>
To: <mysql (AT) lists (DOT) mysql.com>
Sent: Tuesday, February 06, 2007 11:26 AM
Subject: Re: How find duplicate entries

SELECT foobar,
****(foobar) AS NFoos
FRM bar
GRUP BY foobar
HAVING ( ****(foobar) 1 )

2/6/07, T Abad F <informatica (AT) vipventa (DOT) comwrote:
Any can tell me a slq to find duplicate entries in a table?
>
>
>
Thanks,

T
--