SQL query to find the duplicate record with its count in SQL Server

Amatya
Posted by Amatya under Sql Server category on | Points: 40 | Views : 424
SQL query to find the duplicate record with its count in SQL Server


Select
dnfName,dnfEmail, COUNT(*) AS dnfCount FROM tblDNF GROUP BY dnfName,dnfEmail HAVING COUNT(*)>1


Thanks
Amatya

Comments or Responses

Login to post response