FROM SUBQUERY

INSERT using SUBQUERY according to the grammar.

Grammar Syntax

<insert statement> ::=
  INSERT INTO <insertion target>  <insert columns and source> 
<insertion target> ::=
  <table name> 
<insert columns and source> ::=
    <from subquery> 
  | <from constructor> 
  | <from default> 
<from subquery> ::=
  [ <left paren>  <insert column list>  <right paren>  ]
      [ <override clause>  ]
      <query expression> 

Click here to go to the ANSI SQL Standard specification for this syntax.

This syntax is fully supported by Snowflake.

Sample Source Patterns

ANSI SQL Input Code

INSERT INTO TABLENAME ( COL1, COL2, COL3)
SELECT COL1, COL2, COL3 
FROM OTHERNAME;

Snowflake Output Code

INSERT INTO TABLENAME ( COL1, COL2, COL3)
SELECT COL1, COL2, COL3 
FROM OTHERNAME;

Last updated