I need some help please, I have a query that is bringing back data for 2 columns and looks something like this.
How do use the COUNT function so I can display something like this:
Everything I am trying keeps bring back 1 row of data.
Code:
ID Fruit
----------------
1 Apple
1 Apple
2 Banana
2 Banana
2 Banana
3 Orange
4 Grapes
4 GrapesHow do use the COUNT function so I can display something like this:
Code:
ID Fruit Total
--------------------
1 Apple 2
2 Banana 3
3 Orange 1
4 Grapes 2Everything I am trying keeps bring back 1 row of data.
