How to INSERT values in a table using SELECT query in SQL?

  • How-Tos FAQs
  • December 16, 2018
Supercharge Your Snowflake SQL
with Datameer's
Data Transformation

This can be done in below:

INSERT INTO orders (ID, customer_name, order_date, total_orders)
SELECT ID, customer_name, order_date, total_orders
FROM orders
WHERE customer_name = 'Jack'

We replace VALUES statements using SELECT… FROM. The SELECT statement will support all the keys like a regular select query like WHERE, ORDER BY, GROUP BY, etc.


Up Next:

Read How to insert the result of a stored procedure in a table in SQL?