Access数据库用SQL语句删除重复的数据！

2025-06-24 16:19:24

推荐回答（2个）

回答1：

select * from 表 where name not in (select name from ( select name,count(id) as cid from 表 group by name) where cid>1 )

————————————————————————————

select * from 表 where name not in (select name from ( select name,count(name) as cid from 表 group by name) where cid>1 )

回答2：

select * from tb name not in (select name from (select name,count(name) as num from tb group by name) where num>1)

Access数据库用SQL语句 删除重复的数据！

Access数据库用SQL语句删除重复的数据！