select num
from @tbl
group by num
having (count(num)& 1 )> 0  and (count(num)-sum(UndoCorr))> 0 

declare @tbl table (num int not null,UndoCorr tinyint,s int)
 -- UndoCorr if 1 then corr
 
 --          if 0 then undo
 
select num
from @tbl
group by num
having (count(num)& 1 )> 0  and (count(num)-sum(UndoCorr))> 0 

declare @tbl table (num int not null,UndoCorr tinyint,s int)
declare	@c int,@c1 int
set @c= 1 
set @c1= 0 
 -- UndoCorr if 1 then corr
 
 --          if 0 then undo
 
while @c< 10 
begin
print @c
  while @c1< 10 
  begin
print @c1
    insert into @tbl values(@c+@c1,(((((@c1+ 1 )* 10 )*@c)/(@c+@c1))^ 5 )& 1 , 0 )
    set @c1=@c1+ 1 
  end
  set @c1= 0 
  set @c=@c+ 1 
end
select * from @tbl t order by num
select num,count(num),sum(UndoCorr)
from @tbl t
group by num
having (count(num)& 1 )> 0  and (count(num)-sum(UndoCorr))> 0 

select policy_id,count(policy_id)
from #policy
group by policy_id
having (count(policy_id)& 1 )> 0  and 
sum(case status when 'REVERCED' then  1  else  0  end)<sum(case status when 'ADJUSTED' then  1  else  0  end)