/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

0 vote122 views1 answer
Kannst du deine finger trainieren
SQL
1 vote199 views1 answer
Epoch time converter in snowflake
SQL
1 vote172 views1 answer
Convert epoch to date in sql server
SQL
0 vote270 views1 answer
Get statis values sql
SQL
1 vote218 views2 answers
Sql split string by space
SQL
0 vote183 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote164 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote173 views1 answer
Sql where time stamp is in between
SQL
18 votes171 views6 answers
Drop table if exists
SQL
7 votes202 views1 answer
Sql disable safe mode
SQL