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.
 
Back
Top