/SQL/Insert multiple rows from another table sql

Insert multiple rows from another table sql

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;

Insert multiple rows from another table sql

INSERT INTO NewTable SELECT * FROM ExistingTable;

Similar codes

1 vote412 views1 answer
Sql random sampling per group
SQL
0 vote376 views1 answer
Sqlcmd no headers
SQL
0 vote369 views1 answer
QCompleter con sql
SQL
0 vote352 views2 answers
Mysql select date from datetime
SQL
2 votes361 views5 answers
SQL trigger
SQL
0 vote346 views1 answer
Difference between varchar and varchar2
SQL
6 votes417 views3 answers
Check if string contains substring sql
SQL
0 vote356 views1 answer
First Step in installing SQL workbench
SQL
0 vote362 views1 answer
Create database store
SQL
2 votes381 views1 answer
Sqlplus clear screen
SQL