oracle 如何筛选重复,求sql--筛选A字段相同，B字段不同且不重复的记录

测试数据：

create table PRICE

(

ID    VARCHAR2(10),

PRICE NUMBER,

SYSID VARCHAR2(10)

);

insert into price (ID, PRICE, SYSID)

values ('10', 1000, '1');

insert into price (ID, PRICE, SYSID)

values ('10', 1000, '2');

insert into price (ID, PRICE, SYSID)

values ('20', 2000, '3');

insert into price (ID, PRICE, SYSID)

values ('20', 2500, '4');

insert into price (ID, PRICE, SYSID)

values ('30', 1000, '5');

insert into price (ID, PRICE, SYSID)

values ('30', 1000, '6');

insert into price (ID, PRICE, SYSID)

values ('30', 1500, '7');

insert into price (ID, PRICE, SYSID)

values ('40', 1000, '8');

insert into price (ID, PRICE, SYSID)