sqlserver 2005重複および削除の表示

delete from web_site 
where title  in (select  title  from web_site  group  by  title  having  count(title) > 1) 
and [id] not in (select min([id]) from  web_site  group by title  having count(title )>1) 

テーブル内の余分な重複レコードを削除し、重複レコードは単一フィールド(title)で判断し、id最小のレコードのみを残す