okay I have a column where for example say I have the number

100423 well I can have another 100423 it is not unique. How can I write code in SQL working in SQL that can do that.

What I am basically trying to do is if there is only one instance of a particular number. I want to get a count of all those, any ideas?