Will this work?
declare @sample table (Status varchar(10), State varchar(20), Name Varchar(10))insert into @sample
select 'Pending', 'Nebraska', 'ABC' union all
select 'Pending', NULL, 'XYZ' union all
select 'Active', NULL, 'PQR'
select *
from @sample
where state is not null
or status not in (select status from @sample group by status having count(*) > 1)
It wont give you "Active NULL PQR" as your query filters records having state=Null
"Don't limit your challenges, challenge your limits"