select
a.CLASS_NAME as  CLASS
,a.PERSON_NAME as  PERSON
,a.AMT as HOUSEHOLDS
from HOUSEHOLD a
join 
(
select PERSON_CODE,CLASS_CODE,
ROW_NUMBER() OVER(PARTITION BY CLASS_CODE order by AMT desc) x
from HOUSEHOLD where PERSON_CODE  <> '1' and CLASS_CODE <> '01'
)
b on a.CLASS_CODE=b.CLASS_CODE and a.PERSON_CODE =b.PERSON_CODE
 where a.PERSON_CODE  <> '1' and a.CLASS_CODE <> '01' and b.x=1