How to delete a duplicate SQL Server entry in a single redundant table?
How do you delete a duplicate SQL Server entry in a single redundant table?
Software/Hardware used:
Software/Hardware used:
ASKED:
June 9, 2008 4:26 PM
UPDATED:
June 16, 2008 8:05 AM
Answer Wiki:
/*How to delete duplicate rows from a table in SQL Server where table is t1 and col1 and col2 column having same value(duplicate) If duplicate row count >2 then change set rowcout value*/
set rowcount 1--to delete only one row
delete from t1
where col1=1 and col2=1
SET ROWCOUNT 0 --to show updadted result
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
