[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