| 1234567891011121314151617181920212223 |
- select distinct "Optiontype",
- "Vehiclequotenumber",
- "Vehicletypenu",
- "Client Db",
- SUM(c23) OVER (partition by "FZG_Nr") as "Gesch_Kosten_Stuetzung",
- SUM(c22) OVER (partition by "FZG_Nr") as "Gesch_Kosten_Gesamt",
- SUM(c21) OVER (partition by "FZG_Nr") as "Tatsaechl_Kosten_Stuetzung",
- SUM(c20) OVER (partition by "FZG_Nr") as "Tatsaechl_Kosten_Gesamt",
- "FZG_Nr"
- from
- (select (T1."VehicleTypeNU" + (((T1."VehicleQuoteNumber")))) as "FZG_Nr",
- T1."Client_DB" as "Client Db",
- T1."VehicleTypeNU" as "Vehicletypenu",
- T1."VehicleQuoteNumber" as "Vehiclequotenumber",
- T1."OptionType" as "Optiontype",
- CASE WHEN (T1."AnalysisCode" <> 'V') THEN (T1."ActualCost") ELSE (0) END as c20,
- (CASE WHEN (T1."AnalysisCode" = 'V') THEN (T1."ActualCost") ELSE (0) END) as c21,
- (CASE WHEN (T1."AnalysisCode" <> 'V') THEN (T1."EstimatedCost") ELSE (0) END) as c22,
- (CASE WHEN (T1."AnalysisCode" = 'V') THEN (T1."EstimatedCost") ELSE (0) END) as c23
- from "AUTOLINE"."import"."VS_VehicleSpecification" T1
- where (T1."OptionType" = 'N')
- ) D1
- -- order by "FZG_Nr" asc,"Vehiclequotenumber" asc
|
