Getting frustrated with this... I usually can figure this stuff out but for some reason I am stumped on this one.
I have a table (fax_data) that has a notes field in it. What I want to do is show the distinct values in the notes field, and show how many times that value appears. The distinct values are easy, but I was trying to use the count function to count how many times the value appears. If anybody can show me how to do the second part, that would be great.
SELECT DISTINCT notes
FROM dbo.fax_data