1 查找多个字段同时重复的记录
select distinct a.id,a.treeid,a.xh,a.namege from x_spzl a,x_spzl b where b.id<>a.id and b.namege=a.namege and b.xh=a.xh order by a.namege,a.xh
2 1 查找单个字段重复的记录
select * from x_spzl where id in (select Id from x_spzl group by id having count(id)>1)