/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

2 votes170 views1 answer
Oracle index size
SQL
0 vote153 views1 answer
Import sql mysql ubuntu
SQL
2 votes172 views2 answers
Select list is not in group by clause
SQL
-1 vote184 views1 answer
Module operator in oracle sql
SQL
0 vote127 views1 answer
Postgresql subquery
SQL
15 votes363 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote224 views1 answer
Generate random & unique mysql string
SQL
0 vote210 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote171 views1 answer
Tsql cmd exec script from file
SQL
11 votes262 views2 answers
Sql between date range
SQL