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 |
|
mavericky
Posting Yak Master
117 Posts |
 Posted - 2011-09-28 : 09:36:50
|
| Hi,How to delete duplicate records from a table in sql server?Thanks,Mavericky |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-09-28 : 09:40:08
|
You can use row_number() and delete all entries > 1
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 10:04:16
|
| what do you mean by duplicate? on what columns basis you determine duplicate? Show some sample data and explain which rows you want to exclude.generically method suggested by Webfred should work------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
delete duplicate records from a table