AnsweredAssumed Answered

Count number of times value appears in particular column

Question asked by glupoi on Apr 20, 2017
Latest reply on Apr 21, 2017 by user19745

This has probably been asked before, but I'm unable to make my way through the myriad of search results.

What is the most optimized way to count the number of times each distinct value of column x was used?

e.g. Given a table containing

mike mary mike

Return results like:

mike 2 mary 1

Thanks in advance

Outcomes