I have two polygons with same value in the field Field1 (I know this value), and different values in field Field2. I need to know whether that list of polygons contains polygons with different values in field Field2. I do not need to know that values.
I try to write WHERE in ArcMap -> Select by Attributes:
(SELECT * FROM sde_table_name WHERE:) /*this is a standard row (in ArcMap) that I couldn't change*/
objectid IN (SELECT objectid FROM sde_table_name WHERE Field1=12345 group by objectid having count(distinct Field2) >1)
This returns nothing, but I definitely have 2.
Any help would be appreciated.
It is for 10.3 version and Informix database.