Values Clause
Description
Derives a result table by specifying the actual values, using expressions or row expressions, for each column of a row in the result table. hin
Grammar Syntax

Sample Source Patterns
The Values clause is not supported in Snowflake. For this reason, the values clause is translated to a select query.
IBM DB2
VALUES
1, 2, 3
Snowflake
SELECT
1, 2, 3
For the values with multiples rows an Union is used:
IBM DB2
VALUES
(1, 1, 1),
(2, 2, 2),
(3, 3, 3)
Snowflake
SELECT
1, 1, 1
UNION
SELECT
2, 2, 2
UNION
SELECT
3, 3, 3
Last updated
Was this helpful?