gojets1721
Registered User.
- Local time
- Today, 10:53
- Joined
- Jun 11, 2019
- Messages
- 430
I have a query which groups and counts values, and only shows the ten highest (SELECT TOP 10). It basically looks like this:
I want to add a prefix number to the subcategory field so that it basically shows up as:
Suggestions on if that's possible? I can post my SQL code if beneficial
SubCategory | CountofSubCategory |
Henry | 67 |
John | 53 |
....and so on |
I want to add a prefix number to the subcategory field so that it basically shows up as:
SubCategory | CountofSubCategory |
1. Henry | 67 |
2. John | 53 |
...and so on |
Suggestions on if that's possible? I can post my SQL code if beneficial