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