AnsweredAssumed Answered

How to find whether a list of features contains features with same Field1 values and different Field2 values

Question asked by mik1971 on Aug 23, 2015
Latest reply on Aug 27, 2015 by mik1971

Hi there,

 

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.

Outcomes