Hi all, I want to select a service_id whose charge type = 'RCs' in isolation. So if their other charge types for the same service_id I don't want it. Please see the sample data and the result I want. I am using a very old Oracle 9i. Many thanks
CREATE TABLE table1
(
SERVICE_ID VARCHAR2(50)
, BAN VARCHAR2(20) NOT NULL
, DOMAIN VARCHAR2(30)
, CHARGE_TYPE VARCHAR2(30) NOT NULL
)
Insert into table1 (SERVICE_ID,BAN,DOMAIN,CHARGE_TYPE) values ('0XXX104413','20XXX75438158','Mobile','DDP');
Insert into table1 (SERVICE_ID,BAN,DOMAIN,CHARGE_TYPE) values ('0XXX104413','20XXX75438158','Mobile','RCs');
Insert into table1 (SERVICE_ID,BAN,DOMAIN,CHARGE_TYPE) values ('0BBB112529','20XXX45118773','Mobile','RCs');
Insert into table1 (SERVICE_ID,BAN,DOMAIN,CHARGE_TYPE) values ('0ZZZ375066','20XXX15941881','Mobile','Main Plan');
Insert into table1 (SERVICE_ID,BAN,DOMAIN,CHARGE_TYPE) values ('0ZZZ375066','20XXX15941881','Mobile','RCs');
This what I am expecting in the result. Many thanks
"SERVICE_ID","BAN","DOMAIN","CHARGE_TYPE"
"0BBB112529","20XXX45118773","Mobile","RCs"
SORRY edited the record