| 12345678910111213 |
- select T1."EBENE11" as "Ebene11",
- T1."EBENE12" as "KST_mit_Bez",
- T1."EBENE13" as "Ebene13",
- T1."EBENE14" as "Ebene14",
- T1."EBENE15" as "Ebene15",
- T1."EBENE16" as "Ebene16",
- T1."EBENE17" as "Ebene17",
- T1."EBENE18" as "Ebene18",
- T1."EBENE19" as "Ebene19",
- T1."EBENE20" as "Ebene20",
- CASE WHEN (T1."EBENE12" = '100 - Bilanz') THEN ('100') ELSE ((left(T1."EBENE12",2))) END as "KST"
- from "Herkunft_KST.csv" T1
- where (((CASE WHEN (T1."EBENE12" = '100 - Bilanz') THEN ('100') ELSE ((left(T1."EBENE12",2))) END) BETWEEN '00' AND '99') and ((CASE WHEN (T1."EBENE12" = '100 - Bilanz') THEN ('100') ELSE ((left(T1."EBENE12",2))) END) <> '100'))
|
