I'm trying to sort a grouped view in order of the groupings with the most records. (I need to prioritize where to spend limited resources and this will help greatly).
In my speaker database going back 25 years, some speakers have appeared 10+ times, others only once. Here's a shot of the grouped view. How do I sort by count, largest to smallest?
And if you can think of a different way to sort by count (instead of using a grouped view) I'm all ears!
Thanks.
Solved! Go to Solution.
Yep. Check out COUNT() and SELECT() for both.
User | Count |
---|---|
19 | |
13 | |
8 | |
3 | |
2 |