duplicate check on multiple col in sql server 2000

[spaliwal]

Hi,

Pl. anybody suggest me sql query to select duplicates on combination of multiple columns say columns A, B, C, D of table MyTab .

Thanks,

Shailesh

 

[SteveMac32]

This will return you all the duplicates in MyTab based on the columns A,B,C,D.

SELECT COUNT(*), columnA, columnB, columnC, columnD
FROM MyTab
GROUP BY columnA, columnB, columnC, columnD
HAVING COUNT(*) > 1
ORDER BY columnA

Steve Mac

 

[spaliwal]

Hi Steve,

Thanks a lot, it worked and solved my problem.

Thanks again,

Shailesh