Answers for "insert into from a select statement"

SQL
7

sql server insert into select

INSERT INTO sales.addresses (street, city, state, zip_code) 
SELECT
    street,
    city,
    state,
    zip_code
FROM
    sales.customers
ORDER BY
    first_name,
    last_name;
Posted by: Guest on March-05-2020
11

insert into values select

INSERT INTO my_table SELECT * FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table;
INSERT INTO my_table (a, b, c) SELECT a, b, c FROM source_table s
	WHERE s.my_col >= 10;
Posted by: Guest on May-02-2021

Code answers related to "insert into from a select statement"

Code answers related to "SQL"

Browse Popular Code Answers by Language