How to copy data in sql

Migrate sql table another database

INSERT INTO dbo.YourTableNameHere
   SELECT *
   FROM [SourceServer].[SourceDatabase].dbo.YourTableNameHere

How to copy data in sql

INSERT INTO my_table my
SELECT * FROM another_table an
WHERE an.col1 > 10;

INSERT INTO my_table (colA, colB) 
SELECT an.col1 AS colA, an.col2 AS colB FROM another_table an
WHERE an.col1 > 10;

Similar codes

0 vote238 views1 answer
Sql add calculated column
SQL
8 votes230 views1 answer
Insert a select statement into a table
SQL
0 vote233 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote256 views1 answer
Mysql zerofill
SQL
0 vote252 views2 answers
While mysql
SQL
1 vote232 views1 answer
Import sql file mysql commadn line
SQL
0 vote257 views2 answers
Mysql dump database tables only
SQL
0 vote242 views1 answer
Sqlalchemy query join many to many
SQL
0 vote254 views1 answer
Store case result sql
SQL
16 votes233 views3 answers
Delete row psql
SQL