How do you look for duplicate rows in a data table?

[bklabel1]

Q: How do you look for duplicate rows in a data table?

I think that the answer is to use GROUP BY but I'm not sure.

Also a sub query that calls itself with @ parameters might work but I'm also not sure it is correct or how to do this.

Suggestions anyone?

Thanks,

Kevin

[NoUse4aName]

c# - Best way to remove duplicate entries from a data table - Stack Overflow

[bklabel1]

NoUse4aName,
I appreciate the link and it is some good Java to study.
The question they asked was how to find them and not how to remove them.
i guess I could alter the code and make an output list of the duplicates.
Thanks,
Kevin

[bklabel1]

I looked again and noticed that it is C# rather than Java. I didn't realize that they look so similar.
Thanks,
Kevin

[NoUse4aName]

Yeah, language is largely irrelevant. Just need the algorithm then you can implement in appropriate language. In vbs for example the hash table just becomes a dictionary.

The array duplicateList in that code will give you the duplicate list. Just remove the remove command.