sql取不重复多字段

select       *       from       [ table ]            
   where       [ Name ]       in ( select           [ Name ]       from       [ table ]       group       by       [ Name ]       having       count ( [ Name ] ) = 1 )

用distinct使重复的数据只显示一个,可是遇到一个问题,从数据库中打开单一字段可以,打开多个字段则显示全部数据

转载于:https://www.cnblogs.com/zwl12549/archive/2007/11/05/949868.html