sql删除重复数据

来源:互联网 发布:洪恩软件开天辟地4 编辑:程序博客网 时间:2024/06/09 19:57

select count(*)  from table1 where [id] in( select min(id) from  table1 group by keywords)


delete from table1 where [id] not in( select min(id) from  table1 group by keywords) 

原创粉丝点击