SELECT * FROM table T WHERE NOT EXISTS (SELECT 1 FROM table T1 WHERE TRUNC(T1.CREATEDATE) > TRUNC(T.CREATEDATE))