Hi ,
Try this query...
SELECT COUNT(*), column1, column2 FROM tablename
GROUP BY column1, column2
HAVING COUNT(*)>1;
Thanks,
ViSolve DB Team
- Original Message -
From: "Tomás Abad Fernández" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 06, 2007 9:57 PM
Subject: How find duplicat
That actually should be
HAVING ( NumOfFoos > 1 )
- Original Message -
From: "Lars Schwarz" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 06, 2007 11:26 AM
Subject: Re: How find duplicate entries
SELECT foobar,
COUNT(foobar) AS NumOfFoos
FROM bar
GROUP BY fo
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 2
