optimization tecqiue

WITH MAX_DATE AS (SELECT MAX(DATE) AS MAX_DATE FROM DEMODB.EMP) SELECT * FROM DEMODB.EMP A, MAX_DT B WHERE A.DATE=B.MAX_DATE;