How about something like this?

Declare @Table Table (OrderNo int, [LineNo] int, Product varchar(50), Result varchar(50))

Insert Into @Table

Select 1,1, 'ABC', NULL UNION ALL

Select 1,2, 'XYZ', 'Requires Review' UNION ALL

Select 2,1, 'FooBar', NULL UNION ALL

Select 2,2, 'ID10t', NULL

Select * from @Table

where OrderNo Not IN

(Select OrderNo From @Table Where Result IS NOT NULL)