I am trying to find duplicate fields in my table. I am using mssql 2008
I tried something like this but it does not return any records.
group by province,county,districtNcity,citycode
having count(*) > 1
BUT when I try this it returns many records
group by districtNcity
having count(districtNcity) > 1
I want the query to return all the cols and find duplicates in all the cols.