I have a view in SQL server that displays part numbers. I want to count the number of times each part number is present. There are several hundred part numbers.
96475 should return 2
98272 should return 3
all the others should return 1
Not sure how to add a count field to the view.