select distinct([sc1].[Row])
from [ScreenControl] as [sc1]
where [sc1].[FK_Section_ID] = 2
and [sc1].[RepeatID] =  9
and [sc1].[SubRepeatID] = 0
and [sc1].[Row] not in
(
  select [sc2].[Row]
  from [ScreenControl] as [sc2]
  where [sc2].[FK_Section_ID] = 2
  and [sc2].[RepeatID] =  9
  and [sc2].[SubRepeatID] <> 0
)

select distinct([sc1].[Row])
from [ScreenControl] as [sc1]
left join [ScreenControl] as [sc2]
  on [sc2].[Row] = [sc1].[Row]
  and [sc2].[FK_Section_ID] = [sc1].[FK_Section_ID]
  and [sc2].[RepeatID] = [sc1].[RepeatID]
where [sc1].[FK_Section_ID] = 2
and [sc1].[RepeatID] =  9
and [sc1].[SubRepeatID] = 0
and [sc2].[SubRepeatID] <> 0

-- sample table
declare @ScreenControl table (Row int, FK_Section_ID int, RepeatID int, SubRepeatID int)

-- sample data
insert @ScreenControl(Row, FK_Section_ID, RepeatID, SubRepeatID)
select 1,2,9,0 union all
select 1,2,9,1 union all
select 1,2,9,2 union all
select 2,2,9,0 union all
select 3,2,9,0 union all
select 4,2,9,0 union all
select 4,2,9,1 union all
select 5,7,8,0

-- show sample data
select * from @ScreenControl

-- solution using NOT EXISTS()
select row from @ScreenControl s1
where s1.FK_Section_ID = 2
  and s1.RepeatID = 9
  and s1.SubRepeatID = 0
  and not exists(select * 
                 from @ScreenControl s2 
                 where s1.row = s2.row
                   and s1.FK_Section_ID = s2.FK_Section_ID
                   and s1.RepeatID = s2.RepeatID
                   and s1.SubRepeatID <> s2.SubRepeatID)

-- solution using LEFT JOIN
select s1.row 
from @ScreenControl s1
left join @ScreenControl s2
on	s1.row = s2.row
	and s1.FK_Section_ID = s2.FK_Section_ID
	and s1.RepeatID = s2.RepeatID
	and s1.SubRepeatID <> s2.SubRepeatID
where s1.FK_Section_ID = 2
  and s1.RepeatID = 9
  and s1.SubRepeatID = 0
  AND s2.row IS NULL