从多条某几个字段重复的记录中筛选出这几个字段不重复的所有记录

select  a. newid ,a.重复字段一,a.重复字段二,b.其他字段  from  ( select  重复字段一,重复字段二, min (id)  as   newid    from  表名  group   by  重复字段一,重复字段二  order   by  重复字段一,重复字段二)  as  a  inner   join  表名  as  b  on  a. newid = b.id

转载于:https://www.cnblogs.com/Heroman/archive/2007/10/22/933033.html