Remove duplicates

[MeganP]

I know the SQL (in Oracle) for removing duplicates (leaves one record). Can some one translate the below or write new one in T-SQL?

delete from my_table t1
where exists (select 'x' from my_table t2
where t2.key_value1 = t1.key_value1
and t2.key_value2 = t1.key_value2
and t2.rowid > t1.rowid);

Thanks!

 

[SQLBill]

Please check the FAQs before you post....there is a FAQ on handling Duplicates that might help you.

FAQ183-2682

-SQLBill


Posting advice: FAQ481-4875