Delete Duplicate Records

  • Thread starter Thread starter Peter Nunez
  • Start date Start date
P

Peter Nunez

I need to use SQL to delete duplicate records in my table.

What is the syntax for this. My table name is Cause.

The field names are ErrKey, Cause, Description

Thanks, Peter
 
Use the Query Wizard to create a FIND DUPLICATE query.
Make sure it gives you what you want and then view its SQL
and work from there.
 
You must log in or register to reply here.

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

How to Delete duplicate row access 2003 0
remove duplicate records in Access 2007 7
Deleting Duplicate Records in a Query 5
Duplicates in union query 3
Deleting Duplicates 1
Deleting duplicate records 3
Delete duplicate records 17
deleting duplicate records obtained from a duplicate query 4

Back
Top