MS Access：筛选经纬度一致、Object_Number不同且非“-”的重复项

原查询仅筛选了经纬度重复的记录，未处理Object_Number的相关限制，以下是修改后的完整SQL代码，可同时满足条件3和4：

SELECT ['Database].Latitude, ['Database].Longitude, ['Database].Object_Number
FROM ['Database]
WHERE 
    ['Database].Object_Number <> '-'
    AND ['Database].Latitude IN (
        SELECT [Latitude] 
        FROM ['Database] As Tmp 
        WHERE Tmp.Object_Number <> '-'
        GROUP BY [Latitude], [Longitude] 
        HAVING 
            Count(*) > 1 
            AND [Longitude] = ['Database].[Longitude]
            AND MIN([Object_Number]) <> MAX([Object_Number])
    )
ORDER BY ['Database].Latitude, ['Database].Longitude;

修改说明： #

• 适配条件4：主查询和子查询中都添加Object_Number <> '-'，直接排除所有Object_Number为“-”的记录，确保配对对象均符合要求。
• 适配条件3：子查询的HAVING子句新增MIN([Object_Number]) <> MAX([Object_Number])，保证同一经纬度分组内存在至少两个不同的Object_Number，满足“配对对象编号不同”的要求。

内容的提问来源于stack exchange，提问作者sekutor