2 Replies Latest reply on Sep 27, 2018 11:31 AM by Joe Oppelt

    How to get date with max number of records

    Stefano Ballerini

      Hi,

       

      I looked for similar questions but i was not able to find a proper solution to this simple problem:

      How do i select the date (dd/mm/yyyy) having the max number of records.

      In SQL i would achieve this using the "HAVING" clause

       

      I found a similar question

      How to get associating date for Max Value

      which unfortunately does not apply to my case since following the same procedure i end up with an error:

      "cannot mix aggregate and non-aggregate with this function"

       

      Can someone help?

       

      Thank you