SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

WITH yourTable AS (
    SELECT 1731844 AS id, 2 AS unitId, 10 AS cleanCode, 'Not Started' AS stat UNION ALL
    SELECT 1672642, 2, 2, 'Not Started' UNION ALL
    SELECT 1672635, 36, 10, 'Not Started' UNION ALL
    SELECT 1701916, 36, 2, 'Not Started' UNION ALL
    SELECT 1722286, 50, 2, 'Not Started' UNION ALL
    SELECT 1709702, 50, 10, 'Not Started' UNION ALL
    SELECT 1674401, 139, 10, 'Started' UNION ALL
    SELECT 1793677, 139, 2, 'Started' UNION ALL
    SELECT 1769631, 149, 2, 'Not Started' UNION ALL
    SELECT 1769333, 149, 10, 'Started' UNION ALL
    SELECT 1785332, 192, 2, 'Not Started' UNION ALL
    SELECT 1780743, 192, 10, 'Not Started' UNION ALL
    SELECT 1715483, 201, 10, 'Not Started' UNION ALL
    SELECT 1725763, 201, 2, 'Not Started' UNION ALL
    SELECT 167447, 203, 10, 'Not Started' UNION ALL
    SELECT 1732723, 203, 2, 'Not Started'
)

SELECT DISTINCT t1.unitId
FROM yourTable t1
INNER JOIN yourTable t2
    ON t1.unitId = t2.unitId AND
       t1.id <> t2.id AND
       t1.cleanCode <> t2.cleanCode AND
       t1.stat <> t2.stat;

unitId
149