Deleting Duplicate Records

E

Emily

I have combined two tables into one and I have some
duplicate records as a result. I did a duplicate query
and found the duplicates and then I wanted to delete out
one of the records so there was no longer a duplicate.
When I do a delete query on the duplicate query, it wants
to take out both records. How do I keep one and delete
the other????
 
P

pari

Hi Emily...

for ur query no need to creat table for duplicate data and then tr
to remove duplicate records...u can just remove duplicate records in u
original table also..just use DISTINCT in ur query...Foe Example....

select DISTNCT EMPID, EMPNAME from EMPLOYEE


hop this will help u...


...Par
 
Top