select HOUSEHOLD.CLASS_NAME as CLASS,HOUSEHOLD.PERSON_NAME as PERSON,HOUSEHOLD.AMT as HOUSEHOLDS
from 
(
    select CLASS_NAME , MAX(AMT) MAXAMT
    from HOUSEHOLD
    where CLASS_CODE !='01' and PERSON_CODE != '1'
    GROUP BY CLASS_NAME
) HOUSEHOLD1,
HOUSEHOLD
where (CLASS_CODE !='01' and PERSON_CODE != '1')
and HOUSEHOLD1.CLASS_NAME = HOUSEHOLD.CLASS_NAME 
and HOUSEHOLD1.MAXAMT = HOUSEHOLD.AMT 
order by CLASS_CODE