Query for multiple occurance in Column

[Nikhil Bhivgade]

Query for multiple occurrence in Column in a table or to count which record is occur multiple time

[Pete OHanlon]

This is really a SQL question rather than a C# one. To do this, you can use

select id, count(1) from mytable group by id
having count(1) > 1

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx