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