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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-01 : 11:22:10
|
Mads Krog-Jensen writes "In regards to the answer in
"Is there a SQL that I can use to delete duplicate entries from a data store, while leaving a distinct copy - leave a single copy, remove all duplicate except one? "
I am looking for a way to delete records where I look in two fields.
I have a link collection where I have all my links in categories.
Now I would like to erase all links where the URL and the category.ID is the same. Meaning I would like to look into two fields that match and erase them, leaving only one record left.
All my links have a unique ID in a field just called ID.
I am running an SQL 7.0 server." |
|
|
|
|
|
SQL to delete duplicate.