/SQL/Sql insert multiple rows from select

Sql insert multiple rows from 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;

Similar codes

3 votes182 views1 answer
Oracle revoke
SQL
6 votes162 views1 answer
Oracle rank() over (partition)
SQL
0 vote177 views1 answer
How to get specific salary in sql
SQL
0 vote180 views2 answers
Sql query for getting details by id
SQL
0 vote162 views3 answers
Sql count condition
SQL
4 votes173 views1 answer
Update table from another table oracle
SQL
1 vote177 views2 answers
Change table name phpmyadmin
SQL
0 vote205 views1 answer
Mysql last friday of current month
SQL
13 votes172 views5 answers
Oracle list tables
SQL
0 vote216 views3 answers
Mysql keyword search
SQL