1 Reply Latest reply: Dec 26, 2016 6:10 AM by Manish Kachhia RSS

    How to get the value of maximum count from a column

    Deepak K M

      I have 3000 records with 2 column Hashtag and ID,

      I want to get the "value" of maximum number of hashtag in the column. I don't want the count of hashtags.

       

       

      Simple Table values are like this:

      Hashtag          ID

      #a                    20

      #a                    22

      #g                    23

      #h                    33

      #h                    35

      #h                    36

       

      I should get the value "#h" Since it is having maximum count