deleting duplicate rows
-
hi can we delete duplicate rows from a table(there is no primary key) without copying them to another table
-
hi can we delete duplicate rows from a table(there is no primary key) without copying them to another table
Here is a link to an article that explains deleting Duplicate Row's from a Table using Row_Number() function. If you are using sql 2005 then you can refer this one... Delete Duplicate Rows[^]
Regards
J O H N :rose:
"Even eagles need a push." David McNally
-
Here is a link to an article that explains deleting Duplicate Row's from a Table using Row_Number() function. If you are using sql 2005 then you can refer this one... Delete Duplicate Rows[^]
Regards
J O H N :rose:
"Even eagles need a push." David McNally
Thanks John But I am using SQL Server 2000 in which Row_Number() function is not available.