1 Reply Latest reply on Jul 19, 2018 8:22 AM by Joshua Milligan

    Filter on MAX value

    Erik Voges

      I need some help please:

       

      How do I create a filter in Prep that achieves the same result as this where clause in Oracle:

       

      SELECT *

      FROM Transactions

      WHERE Tran_date = (SELECT MAX(Trand_date) FROM Transactions)

       

      ...i.e. I always want only the data relating to the latest date, not a static value

       

      Thanks