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

2 votes350 views1 answer
Oracle current date without time
SQL
1 vote350 views1 answer
Oracle activate job
SQL
0 vote342 views1 answer
Sql not exists
SQL
0 vote344 views2 answers
Postgresql get long running queries
SQL
1 vote346 views1 answer
Postgres first_value in gropby
SQL
1 vote390 views1 answer
Psql filed name alter
SQL
0 vote341 views1 answer
Can we rollback deleted data in sql
SQL
1 vote317 views1 answer
Oracle boolean to varchar
SQL
5 votes360 views4 answers
Select random rows sql
SQL
9 votes340 views1 answer
Oracle get table schema
SQL