Inline Table

Description

An inline table is a temporary table created using a VALUES clause.

Syntax

  1. VALUES ( expression [ , ... ] ) [ table_alias ]

Parameters

  • expression

    Specifies a combination of one or more values, operators and SQL functions that results in a value.

  • table_alias

    Specifies a temporary name with an optional column name list.

    Syntax: [ AS ] table_name [ ( column_name [ , ... ] ) ]

Examples

  1. -- single row, without a table alias
  2. SELECT * FROM VALUES ("one", 1);
  3. +----+----+
  4. |col1|col2|
  5. +----+----+
  6. | one|   1|
  7. +----+----+
  9. -- three rows with a table alias
  10. SELECT * FROM VALUES ("one", 1), ("two", 2), ("three", null) AS data(a, b);
  11. +-----+----+
  12. |    a|   b|
  13. +-----+----+
  14. |  one|   1|
  15. |  two|   2|
  16. |three|null|
  17. +-----+----+
  19. -- complex types with a table alias
  20. SELECT * FROM VALUES ("one", array(0, 1)), ("two", array(2, 3)) AS data(a, b);
  21. +---+------+
  22. |  a|     b|
  23. +---+------+
  24. |one|[0, 1]|
  25. |two|[2, 3]|
  26. +---+------+