好用的SQL收集之分组方式删除重复记录只留下其中一条
[code="sql"]
delete from [tablename] where id not in (select min(id) from [tablename] group by column1,column2,....) and filter
[/code]
column1,column2作为分组字段,就是作为你查重字段,分组的意义就是记录中以分组字段作唯一标准对数据进行分组...
2011-06-02 15:49:10 ·
665 阅读 ·
0 评论