Maximum/ Greatest date from each set of similar rowset

You may use Getdate() if you are using SQL SERVER

SELECT <fieldnames>  FROM TABLE1 A  WHERE

    A.Date1 =

        (SELECT MAX(A_ED. Date) FROM TABLE1 A_ED

        WHERE A.<Key1> = A_ED.<key1>

          AND A_ED.DATE1 <= SYSDATE)