[thelist] Duplicate Records in SQL
Scott Dexter
sgd at ti3.com
Fri Apr 26 12:16:01 CDT 2002
try using a "Having count(name)>1" in your statment:
SELECT ID
FROM tblFOO
group by ID
having count(name)>1
sgd
> -----Original Message-----
> From: Jay Blanchard [mailto:jay.blanchard at niicommunications.com]
>
> I have a table where I want to find duplicate records, and
> eliminate them
>
>
> SELECT Name, Category, Date
> FROM tblFOO
> WHERE Name = Name
> AND Category = Category
> AND LastDate = LastDate
>
More information about the thelist
mailing list