sql 2005删除重复记录 保留其中一条

有个friend表，字段有id，userid，friendid，status，id只是用来标识的，userid和friendid是varchar类型的，status是int类型的
示例如下：
id       userid         friendid       status
1        TERRY       123               1
2        TERRY        123               1
3        DIMA            SKY              0
4        DIMA             SKY             0

怎样可以变成
id       userid         friendid       status
1        TERRY       123               1
3        DIMA            SKY              0

 

delete from friend where id in (select id from
(select id,userid, row_number() over(partition by userid order by id) as rn from friend )  as a where rn > 1)