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 |
|
sureshkumar
Starting Member
11 Posts |
 Posted - 2004-03-28 : 00:09:00
|
| Iam having a table which having duplicate records.In oracle we can use rowid to delete the records.Can you give me the query how to delete the duplicate recordRegardsSuresh |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-03-28 : 01:22:05
|
| See this article: http://www.sqlteam.com/item.asp?ItemID=3331Also, this question is asked very often here, so you might find plenty of answers if you run a search on "delete duplicates".OS |
 |
|
|
TSQLMan
Posting Yak Master
160 Posts |
Posted - 2004-03-30 : 21:37:59
|
| Good article! Dupe the Dupes |
|
|
|
|
|
|
Deleting the duplicate records