cancel
Showing results for 
Search instead for 
Did you mean: 

Using a recursive statistical total car sales of the first layer

ximen
Participant
0 Kudos
1,787

Classification of Vehicles:

 drop table PRODUCT_CAR;
    create table PRODUCT_CAR(Code varchar(100),Description  varchar(100),parent_id varchar(20))
    insert into PRODUCT_CAR select * from (
     select '0'  as code, 'car'                  as Description,''   as parent_id union all
     select '1'  as code, 'BMW'                  as Description,'0'  as parent_id union all
     select '2'  as code, 'BENZ'                 as Description,'0'  as parent_id union all
     select '3'  as code, 'VW'                   as Description,'0'  as parent_id union all
     select '4'  as code, 'Hummer'               as Description,'0'  as parent_id union all
     select 'B5' as code, 'BMW 5 series'         as Description,'1'  as parent_id union all
     select 'B6' as code, 'BMW 6 series'         as Description,'1'  as parent_id union all
     select 'B7' as code, 'BMW 7 series'         as Description,'1'  as parent_id union all
     select 'Z1' as code, 'BZ Home Series'       as Description,'3'  as parent_id union all
     select 'Z2' as code, 'BZ Sercial series'    as Description,'3'  as parent_id union all
     select '1A' as code, 'BZ A series'          as Description,'Z1' as parent_id union all
     select '1B' as code, 'BZ B series'          as Description,'Z1' as parent_id union all
     select 'ZS' as code, 'BZ S series'          as Description,'Z2' as parent_id union all
     select 'V1' as code, 'VW Home Series'       as Description,'ZS' as parent_id union all
     select 'V2' as code, 'vw Sercial series'    as Description,'3'  as parent_id union all
     select 'V3' as code, 'AUDIO Sercial series' as Description,'3'  as parent_id union all
     select 'V001' as code,  'VW SUVS series'    as Description,'V1' as parent_id union all
     select 'VA01' as code,  'AD HOME Sercial'   as Description,'V3' as parent_id union all
     select 'VA02' as code,  'AD SUVS Sercial'   as Description,'V3' as parent_id union all
     select 'VA21' as code,  'AD A Sercial'      as Description,'V3' as parent_id union all
     select 'VA211' as code, 'AD Q Sercial'      as Description,'VA02' as parent_id
    ) a;
    SELECT * FROM PRODUCT_CAR ORDER BY CODE ASC;

Sales Data:

create table SEll_CAR(
   Car_Code     varchar(100),
   Description  varchar(100),
   quantity     numeric(10),
   product_code varchar(20)
);
insert into sell_car select * from (
  select 'B53001'  as Car_code , 'BMW 535 LI luxury cars' as Description, '21'   as quantity, 'B5'    as product_code union all
  select 'B75001'  as Car_code , 'BMW 750 LI XDriver'     as Description, '200'  as quantity, 'B7'    as product_code union all
  select '21101'   as Car_code , 'AD  Q7 luxury cars'     as Description, '30'   as quantity, 'Va211' as product_code union all
  select 'VA211'   as Car_code , 'AD  A6 LI luxury cars'  as Description, '2'    as quantity, 'VA01'  as product_code union all
  select 'VW1001'  as Car_code , 'VW  Cross polo  '       as Description, '100'  as quantity, 'V1'    as product_code
) b;
select * from sell_car;

result:

PRODUCT_CAR.code  PRODUCT_CAR.Description  sell.Sell_SUM
1                 BMW                      221
2                 BENZ                     0
3                 vw                       132
4                 Hummer                   0
Breck_Carter
Participant

This forum is for answering questions about SQL Anywhere, not doing your homework.

VolkerBarth
Contributor
0 Kudos

Furthermore, I guess you have already posted the same here (and I'm not sure whether this is a "question" at all - or a nuisance):

http://sqlanywhere-forum.sap.com/questions/18168/how-i-can-use-of-recursive-query-results-help-thank...

ximen
Participant
0 Kudos

According to the brand (layer 1) according to sales situation

Accepted Solutions (0)

Answers (0)