SELECT
MAXDATE AS CK_DATE,
 A.MEMBER_CODE AS CODE
FROM
(
SELECT
 MAX(CHECKUP_DATE) AS MAXDATE,
 MEMBER_CODE
FROM
 HEALTH_CHECKUP
GROUP BY
 MEMBER_CODE
 ) A
INNER JOIN
(
SELECT
 CHECKUP_DATE AS SECONDDATE,
 MEMBER_CODE
FROM
 HEALTH_CHECKUP B
WHERE NOT EXISTS
(
 SELECT
  MAXDATE,
  MEMBER_CODE
 FROM
(
SELECT
 MAX(CHECKUP_DATE) AS MAXDATE,
 MEMBER_CODE
FROM
 HEALTH_CHECKUP
GROUP BY
 MEMBER_CODE
) 
 WHERE
 MAXDATE = B.CHECKUP_DATE
AND
 MEMBER_CODE = B.MEMBER_CODE
) 
) D
ON
 D.MEMBER_CODE = A.MEMBER_CODE