Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Steppin Razor
Starting Member
1 Post |
 Posted - 2005-10-17 : 17:01:13
|
| Obviously, I'm a complete n00b at SQL.I have a table in Access 2003 with about 6,000 records and there are about 20 records that have duplicate data in the first field (CompID).I'm trying to make the first field my primary key, so I need to fix these duplicate entry.I could export to Excel and fix the problem that way, but in the interest of learning SQL I want to figure out how to do it properly.Thanks in advance for what is hopefully a simple answer. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Check for Duplicate Entries in One Field