样本数据：

SQL> with properties (propertyid, countryid) as
  2    (select 12345, 1111 from dual union all
  3     select 12345, 1112 from dual union all
  4     select 23456, 1111 from dual union all
  5     select 34567, 2222 from dual
  6    )

质询：

7  select propertyid
  8  from properties
  9  group by propertyid
 10  having count(distinct countryid) > 1;

PROPERTYID
----------
     12345

SQL>