Ansicht SPKriterien

Abfrage

??? info "SQL"

``` sql

  SELECT "Mandant", "SchuelerZeitraumID", 'A' AS "Typ", "TypA", "WertA1", "WertA2", "WertA3"
  FROM "SchuelerPruefungen"  UNION
  SELECT "Mandant", "SchuelerZeitraumID", 'B' AS "Typ", "TypB", "WertB1", "WertB2", "WertB3"
  FROM "SchuelerPruefungen"  UNION
  SELECT "Mandant", "SchuelerZeitraumID", 'C' AS "Typ", "TypC", "WertC1", "WertC2", "WertC3"
  FROM "SchuelerPruefungen"  UNION
  SELECT "Mandant", "SchuelerZeitraumID", 'D' AS "Typ", "TypD", "WertD1", "WertD2", "WertD3"
  FROM "SchuelerPruefungen"  UNION
  SELECT "Mandant", "SchuelerZeitraumID", 'E' AS "Typ", "TypE", "WertE1", "WertE2", "WertE3"
  FROM "SchuelerPruefungen"  UNION
  SELECT "Mandant", "SchuelerZeitraumID", 'F' AS "Typ", "TypF", "WertF1", "WertF2", "WertF3"
  FROM "SchuelerPruefungen"  UNION
  SELECT "Mandant", "SchuelerZeitraumID", 'G' AS "Typ", "TypG", "WertG1", "WertG2", "WertG3"
  FROM "SchuelerPruefungen" 
  UNION
  SELECT "Mandant", "SchuelerZeitraumID", 'H' AS "Typ", "TypH", "WertH1", "WertH2", "WertH3"
  FROM "SchuelerPruefungen"  UNION
  SELECT "Mandant", "SchuelerZeitraumID", 'I' AS "Typ", "TypI", "WertI1", "WertI2", "WertI3"
  FROM "SchuelerPruefungen"  UNION
  SELECT "Mandant", "SchuelerZeitraumID", 'J' AS "Typ", "TypJ", "WertJ1", "WertJ2", "WertJ3"
  FROM "SchuelerPruefungen"
```