Categories:: Query Syntax

INTO¶

Sets Snowflake Scripting variables to the values in a row returned by a SELECT statement. See Setting Variables to the Results of a SELECT Statement for details.

Syntax¶

SELECT <expression1>
   [ , <expression2> ]
   [ , <expressionN> ]
[ INTO :<variable1> ]
   [ , :<variable2> ]
   [ , :<variableN> ]
FROM ...
WHERE ...
[ ... ]

Copy

Where:

expression1, . expression2, . expressionN: Specifies scalar expressions (e.g. columns in a table specified by the FROM clause).
variable1, . variable2, . variableN: Snowflake Scripting variables that should be set to the values in the expressions in the SELECT clause.

Usage Notes¶

The SELECT statement must return a single row.

Examples¶

See Setting Variables to the Results of a SELECT Statement.