skr_marke.sql 421 B

12345678910111213
  1. select T1."EBENE41" as "Marke_mit_Bez",
  2. T1."EBENE42" as "Ebene42",
  3. T1."EBENE43" as "Ebene43",
  4. T1."EBENE44" as "Ebene44",
  5. T1."EBENE45" as "Ebene45",
  6. T1."EBENE46" as "Ebene46",
  7. T1."EBENE47" as "Ebene47",
  8. T1."EBENE48" as "Ebene48",
  9. T1."EBENE49" as "Ebene49",
  10. T1."EBENE50" as "Ebene50",
  11. (left(T1."EBENE41",2)) as "Marke"
  12. from "Marke.csv" T1
  13. where (((left(T1."EBENE41",2))) IS NOT NULL)