SELECT
A.CLASS_NAME AS CLASS
,A.PERSON_NAME AS PERSON
,A.AMT AS HOUSEHOLDS
from
HOUSEHOLD A
,(
    SELECT
    B.CLASS_CODE
    ,MAX(B.AMT) AS AMT
    FROM
    HOUSEHOLD A
    ,HOUSEHOLD B
    WHERE
    A.CLASS_CODE = B.CLASS_CODE
    AND  B.PERSON_CODE != '1'--(総数)
    AND B.CLASS_CODE != '01'--(総数)
    GROUP BY B.CLASS_CODE
) B
where
A.PERSON_CODE != '1'--(総数)
AND A.CLASS_CODE != '01'--(総数)
AND A.AMT = B.AMT
AND A.CLASS_CODE = B.CLASS_CODE 
ORDER BY
A.CLASS_CODE
;