SQL only row mapping record fetching
- by Prasanna
I have a customer call detail table in which call details of all customer stored. I have to find out the distinct aparty (means our customer ) who only calls our customers (means bparty also be our numbers) . There is no other domestic call , International calls made by A party (our customer) in this case.
could you people please help me to find the same data.
FILE INPUT oF SAMPLE CDR TABLE
ROW NAME VALUES
ANUMBER :-any mobile number(Domestic+International); for our customer it must like 70,070,0070,9370)
BNUMBER :-any mobile number(Domestic+International); for our customer it must like 70,070,0070,9370
CALLTRANSACTION :-eg: 91,92,93 etc
CALLTRANSACTIONTYPEC :-eg: MOC,MTC
FILENAME :-MCS_01 etc
TIME:- any time value
Required Output
DISTINCT ANUMBER :-for our customer it mobile number must start with 70 or 070 or 0070 or 9370
BNUMBER :- for our customer it mobile number must start with 70 or 070 or 0070 or 9370
means our customer only calls to our network customer ( No other doestic call or international calls made by our operator)
