3 Replies Latest reply on Aug 16, 2017 11:49 AM by Deepak Rai

    Attribute max value for entire table

    Frederico Mantelato

      Hi all;

       

      I´m facing an issue about using max and min. I have a several id´s in my dataset and each one has an specific date, as it can be seen below:

        

      IDStart Date
      AAW064331/jul
      AAW064315/jul
      APU697916/jul
      APU697920/jul
      APU697905/jul
      ERB728301/jul
      ERB728303/jul

       

      I need the max start date to attribute for the entire table. So far, I´ve tried to use WINDOW_MAX() and TOTAL(MAX()), but none of them was what I expected. I´m expecting this:

       

      IDStart Date
      AAW064331/jul
      AAW064331/jul
      APU697931/jul
      APU697931/jul
      APU697931/jul
      ERB728331/jul
      ERB728331/jul

       

      Does anyone know how can I do?

       

      Thanks.