sql建立唯一的非聚集索引时由于数据重复建立失败，快速删除重复数据的 巧妙 sql----2

 

 

 

 delete From  weibo 
  where url in 
  (
  select  url from weibo
  group by url
  having count(*)>1
  )
and id not in (
  select  min(id) from weibo
  group by url
  having count(*)>1
  )