/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

16 votes213 views1 answer
Mssql int max value
SQL
0 vote225 views1 answer
Oracle to_number
SQL
0 vote198 views1 answer
Trigger vérifier stock
SQL
0 vote207 views1 answer
Query to remove duplicate rows from a table
SQL
9 votes227 views1 answer
Identity insert on sql server
SQL
7 votes180 views6 answers
Group_concat mysql
SQL
0 vote206 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote184 views1 answer
Create table Statement Syntax in SQL Server
SQL
3 votes181 views1 answer
Uppercase and lowercase in sql
SQL
5 votes207 views1 answer
Oracle list days between two dates
SQL