/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 vote304 views1 answer
Db.Database.SqlQuery
SQL
0 vote256 views1 answer
Postgresql conectar
SQL
0 vote272 views1 answer
Select insert new table sql server
SQL
1 vote283 views2 answers
Postgres select from last 3 months
SQL
0 vote256 views2 answers
Sql server select first day of previous year
SQL
2 votes264 views1 answer
How to delete view in sql
SQL
3 votes253 views4 answers
Mysql delete duplicate rows
SQL
0 vote264 views1 answer
How to create a table in sql stack overflow
SQL
0 vote281 views1 answer
Oracle list partitions
SQL
0 vote248 views1 answer
ORACLE SUBSTRING SYNTAX
SQL