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)
please tell me that is their any unique identifier with which each row in a table is identified like rownum in oracle
Is there any query to duplicate records when we does not have any identity in the table.
i want to delete the duplicate row in table but we have no any primery key in table how it is . pl do this