I have wrote following two articles for Duplicate Rows Management in SQL Server.
SQL SERVER – Count Duplicate Records – Rows
SQL SERVER – Delete Duplicate Records – Rows
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Community Initiatives
About Pinal Dave
Pinal Dave is a Pluralsight Developer Evangelist. He has authored 9 SQL Server database books and have written over 2500 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 9+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ. Prior to joining Microsoft he was awarded the Microsoft MVP award for three continuous years for his contribution in the community. Here is the list of the Pinal Dave's books.
Follow @pinaldave
Send +Pinal Dave an email at pinal@sqlauthority.com-
- 63,264,138 (63 Million+)
SQL in Sixty Seconds
SQL Books
Funny Index Video
SQLAuthority Links
My Homepage
Windows Live Blog
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
All Scripts - 3
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
> SQL Interview Q & A <
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
About Nupur Dave
Top 3 Commenters
-
hi
please tell me that is their any unique identifier with which each row in a table is identified like rownum in oracle
Hi Pinal,
Is there any query to duplicate records when we does not have any identity in the table.
Thanks
Shyam
Dear sir
i want to delete the duplicate row in table but we have no any primery key in table how it is . pl do this
from
krishna
noida