BobLoblaws
Programmer
Is there a way to remove duplicate records quickly? Possibly a query?
Thanks,
Thanks,
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query to remove duplicate records?
- Thread starter BobLoblaws
- Start date
- Status
here is a way of finding duplicates, do with it as you like
SELECT columns(can't be * and must include the column with duplicates)
FROM table
WHERE (((column with dups) In (SELECT [column with dups] FROM
As Tmp GROUP BY [column with dups] HAVING Count(*)>1 )))
ORDER BY column with dups
SELECT columns(can't be * and must include the column with duplicates)
FROM table
WHERE (((column with dups) In (SELECT [column with dups] FROM
ORDER BY column with dups
- Status
Similar threads
- Locked
- Question