With t as (values …)

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200820102012201420162018202020222024⚠ 3.8.3 - 3.50.0a⊘ 3.5.7 - 3.7.11⊘ 2008R2 - 2022⚠ 8.4 - 17a⊘ 8.3⚠ 23.0 - 23.9ab⊘ 11gR1 - 21c⚠ 8.0.19 - 9.3.0c⊘ 5.0 - 8.0.18⚠ 10.3 - 12.0.2a⊘ 5.1 - 10.2⚠ 9.7 - 12.1.2ab⊘ 2.0
  1. Nur ohne Schlüsselwort row
  2. Erfordert Spaltennamen in der With-Klausel: with x (c1,c2) as (values …)
  3. Nur mit Schlüsselwort row: values row('r1c1','r1c2'), row('r2c1', 'r2c2')