Query Delete Duplicates

  • Thread starter Thread starter Royce Schnepp
  • Start date Start date
R

Royce Schnepp

I am trying to delete duplicate imported records in a table. I have done the
find duplicate query wizard. But what I am trying to do is make a Delete
Query that will go through the table and delete duplicate records.

How do I do this?
 
I am trying to delete duplicate imported records in a table. I have done the
find duplicate query wizard. But what I am trying to do is make a Delete
Query that will go through the table and delete duplicate records.

How do I do this?
Click to expand...

Is there a unique key on each row? (better if there is)

What columns taken together make the row unique?

What is the name of the table?
 
There is no primary key, because some data is left blank. It's a foreclosure
data base. So if I set a key it leaves information out. What I am trying to
do is have it go through the database and based on T_S_NO column, select all
the duplicates and erase them from table TDS_MASTER.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Writing SQL code to delete duplicate records 0
Self joined table in a delete query 2
How to Delete duplicate row access 2003 0
duplicates in all fields 1
delete duplicates 5
Yet another duplicate record dilemma 7
Compare 2 tables and delete from one of them 2
Deleting Duplicate Records 4

Back
Top