declare @Sample table(id int, txt varchar(30))
insert @Sample
select 1, 'A' union all
select 1, 'B' union all
select 2, 'C' union all
select 3, 'D'
select * from @Sample
delete dt
from
(select row_number() over (partition by id order by txt) as rn,* from @Sample)dt
where rn > 1
select * from @Sample
No, you're never too old to Yak'n'Roll if you're too young to die.
How to delete
Posted - 06/13/2012 : 08:17:00
