返回记录列表，其中1个ID链接到2个不同的PK

Question

首先，为标题道歉-不知道该怎么写。

本质上我有这样的数据：

会计ID/thead>

ID	规则ID
1	1234	ABC001
2	5678	DEF001
3	1234	GHI001
4	1234	ABC001

您可以按如下方式尝试EXISTS：

SELECT * FROM #rules r
where exists 
(select 1 from #rules rr
where rr.RuleID = r.RuleID and rr.AccountID <> r.AccountID);

SELECT RuleID
FROM #rules
GROUP BY RuleID
HAVING COUNT(distinct AccountID) > 1

或

SELECT RuleID
FROM #rules
GROUP BY RuleID
HAVING min(AccountID) != max(AccountID)