SELECT ACID,ACCT_POA_AS_SRL_NUM,BANK_ID, COUNT(*) TotalCount
FROM abc GROUP BY ACID,ACCT_POA_AS_SRL_NUM,BANK_ID
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
if you've pk set via constraint, it will never have duplicate values
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Findig duplicate using complex key
Posted - 03/02/2013 : 05:43:04
