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)
December 25, 2007 by pinaldave
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)
Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology | 3 Comments
Pinalkumar Dave is a Microsoft SQL Server MVP and a Mentor for Solid Quality India. He has written over 1200 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager, who specializes in SQL Server Programming and has 7 years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCDBA and MCAD (.NET). He is also Regional Mentor for PASS Asia.

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