/*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
Last Wiki Answer Submitted: June 16, 2008 8:05 am by Ramneet45 pts.