select
CLASS_NAME
,PERSON_NAME
,AMT
from
HOUSEHOLD a
INNER JOIN
(
select 
a.CLASS_NAME AS CLASS
,MAX(a.AMT) AS HOUSEHOLDS
FROM
HOUSEHOLD a
where PERSON_CODE!='1'
and CLASS_CODE!='01'
GROUP BY 
CLASS_NAME
)b
ON
a.AMT=b.HOUSEHOLDS