I have a requirement where i need to consider a set as two columns and for that set need to check two exactly available combinations.

findings are to be done partition by ID and CD and for that paritition need to find exactly available values say 'Paid' and 'AdjD'. If that partition set holds more than these two values or less than these two values then those records should not be picked.
Example if the partition set has 'Paid','AdjD', 'AdjV' then these this set should not be considered, as it violates the exactly two distinct records match.

select id,cd,nm
from (select id,cd,nm,
sum(case when nm = 'Paid' then 1 end) over (partition by id,cd order by null
rows between unbounded preceding and unbounded following
) n_paid,
sum(case when nm = 'AdjD' then 1 end) over (partition by id,cd order by null
rows between unbounded preceding and unbounded following
) n_adjd,
sum(case when nm not in ('Paid','AdjD') then 1 end) over (partition by id,cd order by null
rows between unbounded preceding and unbounded following
) n_other
from t
)
where n_paid = 1
and n_adjd = 1
and n_other is null