If you're looking into if table has any two rows that both match some condition you can do a following:

create table Interfaces  (InterfaceName nvarchar(100), status varchar(10))

insert into Interfaces (
    InterfaceName, status
)
values  ('GigabitEthernet1/0/2','4')
,   
('GigabitEthernet1/0/1','1')
,   ('GigabitEthernet1/0/3','2')

SELECT  *
FROM    (
    select  *, COUNT(*) OVER() AS cnt
    from    Interfaces i
    WHERE   (
            (I.[InterfaceName] = 'GigabitEthernet1/0/2' AND I.[Status] = '4')
        OR  (I.[InterfaceName] = 'GigabitEthernet1/0/1' AND I.[Status] != '2')
    )
    ) x
WHERE   cnt >= 2

The OR matches the conditions you're looking for, the COUNT makes sure you get at least two values.

If you have duplicates and want to make sure you get both interfaces and not just duplicate of one interface, it's a bit more complicated. One solution is:

insert into Interfaces (
    InterfaceName, status
)
values  ('GigabitEthernet1/0/2','4')
,   ('GigabitEthernet1/0/1','1')
,   ('GigabitEthernet1/0/1','1')
,   ('GigabitEthernet1/0/3','2')

SELECT  *
FROM    (
        SELECT  *, COUNT(*) OVER() AS cnt
        FROM    (
            select  *, ROW_NUMBER() OVER(PARTITION BY InterfaceName ORDER BY @@SPID) AS rnk
            from    Interfaces i
            WHERE   (
                    (I.[InterfaceName] = 'GigabitEthernet1/0/2' AND I.[Status] = '4')
                OR  (I.[InterfaceName] = 'GigabitEthernet1/0/1' AND I.[Status] != '2')
            )
            ) x
        WHERE   rnk = 1
    ) x
WHERE   x.cnt >= 2

ROW_NUMBER creates a grouping of rows per Interface, for which we only take one, and then by wrapping it in another COUNT(*) OVER() you once again return the two distinct rows