查重

select    (select  1  from  yourtable  x  where  yourtable.fieldname=x.fieldname  group  by  fieldname  having  yourtable.*  from  yourtable  where  existscount(*)>1)