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 - 2002-08-13 : 13:07:12
|
| david writes "I've used the help you provided regardin finding and deleting duplicates. What I'm looking to do is find some way to locate (not delete) those records where two or three fields are the same but one field is different. Any ideas?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-13 : 13:35:12
|
| Use a GROUP BY with a HAVING count(*) > 1 ...(Post your DDL and which columns you are concerned with)Jay White{0} |
 |
|
|
|
|
|
Advanced Duplicates