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