SELECT T.ID ,
T.ADDRESS ,
T.CITY ,
T.POSTAL_CODE ,
T.STATE
FROM dbo.LOCATION T
WHERE EXISTS ( SELECT 1
FROM LOCATION
WHERE ID = T.ID
AND ADDRESS <> T.ADDRESS );
原文：https://www.cnblogs.com/kangjing/p/8979780.html