sql取不重复多字段 select * from [table] where [Name] in(select [Name] from [table] group by [Name] having count([Name])=1) 用distinct使重复的数据只显示一个,可是遇到一个问题,从数据库中打开单一字段可以,打开多个字段则显示全部数据