Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select single count in isolation

ricard888Jul 20 2021 — edited Jul 20 2021

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
This post has been answered by Billy Verreynne on Jul 20 2021
Jump to Answer

Comments

Post Details

Added on Jul 20 2021
#9i
12 comments
277 views
4 mentions