create table #aa(
      a numeric( 15 )
     ,b varchar( 20 )
     ,c money
)

insert #aa
select  159 ,'456', 784 
union
select  159 ,'456', 0 
union
select  434 ,'323', 546 
union
select  667 ,'111', 12 
union
select  125 ,'555', 0 

select * from #aa

select * from #aa a
where  1 = 1 
  and a.c =  0 
  and exists(select  1  from #aa where a.a = #aa.a and #aa.c <>  0 )

delete from #aa
where a in ( 
select a from #aa a
where  1 = 1 
  and a.c =  0 
  and #aa.a = a.a
  and exists(select  1  from #aa where a.a = #aa.a and #aa.c <>  0 )
  )
  and c= 0 
 
select * from #aa

drop table #aa