How to INSERT values in a table using SELECT query in SQL?
- How-Tos FAQs
- December 16, 2018
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?
