Finding duplicates in a field

[AccountingTechie]

Hi all - there is a way to check for existing duplicates in a database using one of the fields (say street address, which of course is not going to be unique) using the word "having". How would you write that select query? Thanks

 

[gmmastros]

Like this...

Select StreetName
From   Address
Group By StreetName
Having Count(*) > 1

You can also add the count to the select list so you can see how many duplicates there are, like this...

Select StreetName, Count(*) As DuplicateCount
From   Address
Group By StreetName
Having Count(*) > 1

Make sense?


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[AccountingTechie]

YES! Bingo. Thank you sir.