VALUES clause

Syntax

VALUES(column_value01, column_value02...) table_name(column_name01,column_name02...)

Parameters

Examples

Use the VALUES clause to insert data into a column named pv in the table named access.

• Query statement
  * |
  SELECT
    pv
  FROM  (
      VALUES
        (0),
        (1),
        (2),
        (3),
        (4),
        (5),
        (6),
        (7),
        (8),
        (9)
    ) AS access(pv)

• Query and analysis results