Hi all, i'm new to SQL and was wondering if anyone can advise on how to count the number of times each number in the count column appears? For example the answer would be 4 for the number of times 3 appears and 5 for the number of times 2 appears. I'm working in Business Objects so can create a separate variable and show the answer in a separate table. I appreciate this is an excel forum so any advise would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
SQL query in BO
- Thread starter iluvsafc
- Start date
Similar threads
- Question
- Question
- Question
