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
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2000 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of three SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.
Nupur Dave loves technology simply because it makes life more convenient. She is devoted to technology because it touches our heart makes our daily lives easier. Among the many technological programs she uses and embraces Windows Live most because she can do lots of things with ease – from photo management to movies; business emails to personal social media connections.
This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet/ BOL. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have documented my personal experience on this blog.
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