Find duplicates

[Bell1991]

how do you find duplictes when you have a primary key that consists of 3 fields? I know how to if i have only one field

Select c from tblName Group By columns having (coulmn) > 1

 

[SQLDenis]

Select field1,field2,field3 from tblName Group By field1,field2,field3 having count (*) > 1

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Bell1991]

thanks!