一种方法是通过连接到查找所有匹配项的子查询来过滤不匹配的记录 SCId 值在表中出现两次。

SELECT t1.*
FROM yourTable t1
INNER JOIN
(
    SELECT SCId
    FROM yourTable
    GROUP BY SCId
    HAVING COUNT(*) = 2
) t2
    ON t1.SCId = t2.SCId;