I need help with writing a query so I figured I'd ask here. Let me thank you in advance for your answer.
I need to see how often a value inside a certain column appears in a table. Say for example I have a table Person, that has a field name.
I want to know top five most frequently occuring names, along with the number indicating how often each appears.