J
Jason Stephens
I have a simple table that has only 2 colums, a name and a type. IE:
Name Type
------------------
Jason 1
Paul 3
John 2
Sally 3
Ron 2
What I need is a query that will give me a count for each type. The example
output for the above data would be:
Type Count
------------------
1 1
2 2
3 2
Etc. What is the correct syntax to get these results? Responses as SQL
statements would be fine. Much love and appreciation!
--Jason
Name Type
------------------
Jason 1
Paul 3
John 2
Sally 3
Ron 2
What I need is a query that will give me a count for each type. The example
output for the above data would be:
Type Count
------------------
1 1
2 2
3 2
Etc. What is the correct syntax to get these results? Responses as SQL
statements would be fine. Much love and appreciation!
--Jason