Groups

    SQL Most and least occurring

    what is the command for the most and least occuring value within a column/field?

    Thanks

    5 Comments

    MAX and MIN?

    Should be MAX (Count) and MIN(Count)

    Original Poster

    Baz123;7932105

    MAX and MIN?



    Most occuring not the highest and lowest

    Original Poster

    Baz123;7932112

    Should be MAX (Count) and MIN(Count)



    as in SELECT MAX(Count(Fieldname))

    ?

    SAVE4IT;7932137

    as in SELECT MAX(Count(Fieldname))?



    Yes I think thats what you need
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Free JackpotJoy Plate56
      2. Win a Free minion usb stick77
      3. Tv choice magazine Issue 391313
      4. Magazine competitions - Issue 38 @ tvchoicemagazine.co.uk1717

      See more discussions