去除ACCESS数据表中所有重复的数据方法
方法及步骤：
1 . 复制数据表的结构到新数据表中
SELECT * INTO 新数据表 FROM 表名 where 1=2
2 . 新建OK显示表中所有不重复的记录
select DISTINCT 字段1, 字段2, 字段3, 字段4, 字段5, ... ... from 表名 GROUP BY 字段1, 字段2, 字段3, 字段4, 字段5, ... ... HAVING count(*) > 1
3 . 统计表中有重复记录各重复的次数
SELECT [2].[字段], Count(*) AS 记录数 FROM 表名 as 2 GROUP BY [2].[字段] HAVING count(*) > 1 ORDER BY [字段];
4 . 将表中所有不重复的数据生成到新数据表中
INSERT INTO 新数据表 ( 字段1, 字段2, 字段3, 字段4, 字段5, ... )
select DISTINCT 字段1, 字段2, 字段3, 字段4, 字段5, ... from 表名 GROUP BY 字段1, 字段2, 字段3, 字段4, 字段5, ... HAVING count(*) > 1
access 不支持distinct 好不