SELECT *
    FROM my_table AS t,
         ( SELECT MAX( date ) AS max_date
             FROM my_table ) AS s
    WHERE t.date = s.max_date;