/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

3 votes244 views4 answers
Show sql server database
SQL
0 vote262 views1 answer
Partitioning in oracle-base
SQL
1 vote264 views1 answer
Mysql return text after a final full stop
SQL
0 vote291 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote263 views1 answer
Sql select inside select sub query
SQL
1 vote244 views1 answer
Truncate table in postgresql and reset id
SQL
6 votes285 views2 answers
Mysql timestamp to date
SQL
0 vote260 views3 answers
Mysql delete if not in another table
SQL
0 vote256 views3 answers
Sql select statements
SQL
0 vote225 views1 answer
Query for maximum salary
SQL