select
--     max()
HO.CLASS_NAME as CLASS,
HO.PERSON_NAME as PERSON,
HO.AMT as HOUSEHOLDS

    from
HOUSEHOLD HO inner join (
select CLASS_CODE,max(amt) as mx_amt from HOUSEHOLD  where PERSON_CODE <> '1' group by CLASS_CODE
) MX
    on HO.CLASS_CODE = MX.CLASS_CODE
    and HO.AMT = MX.mx_amt

where HO.CLASS_CODE <> '01'

group by HO.CLASS_CODE

order by HO.CLASS_CODE
;