1 2 Previous Next 22 Replies Latest reply on Apr 21, 2017 3:41 PM by user19745

    Count number of times value appears in particular column


      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

        1 2 Previous Next