一些tsql的帮助很小

SELECT rowId, AccountId, Organization1, Organization2
FROM   yourTable yt
WHERE  NOT EXISTS (SELECT 1 FROM yourTable yt2 WHERE yt.AccountId = yt2.AccountId AND yt.Organization1 = yt2.Organization2)

SELECT AccountID FROM Table WHERE Organization1 <> Organization2

但我怀疑你是在问更难的解释(其中Organization2不出现在同一帐户的Organization1值中):

SELECT AccountID From Table T1 WHERE Organization2 NOT IN 
  (SELECT Organization1 FROM Table T2 WHERE T2.AccountID = T1.AccountID)

下面是一个你可以做到的方法:

CREATE TABLE #T(rowid int, acc int, org1 int, org2 int)

INSERT #T
SELECT 1,1,10,10  UNION
SELECT 2,1,20,20   UNION
SELECT 3,1,40,30   UNION
SELECT 4,2,10,10   UNION
SELECT 5,2,15,15   UNION
SELECT 6,2,20,20

然后执行自联接以发现缺少的org2:

SELECT
*
FROM #T T1
LEFT JOIN
    #T T2
 ON t1.org1 = t2.org2
AND t1.acc = t2.acc

WHERE t2.org1 IS NULL

SELECT
    *
FROM
    [YorTable]
WHERE
    [Organization1] <> [Organization2]  -- The '<>' is read "Does Not Equal".

使用Noel Abrahams提出的左连接。