select 
 h1.CLASS_NAME as CLASS
,h1.PERSON_NAME as PERSON
,h1.AMT as AMT
from HOUSEHOLD h1
inner join (select 
             h.CLASS_NAME as CLASS
            ,max(h.AMT) AMT
            from HOUSEHOLD h
            where h.CLASS_CODE<>'01'
            and PERSON_CODE<>'1'
            group by
             h.CLASS_NAME ) c
on h1.CLASS_NAME = c.CLASS
and h1.AMT = c.AMT
order by 
 h1.CLASS_NAME