/SQL/Get value from a table an insert it with other values in another table sql

Get value from a table an insert it with other values in another table sql

Get value from a table an insert it with other values in another table sql

INSERT INTO column_1 ( val_1, val_from_other_table ) 
VALUES('val_1', (SELECT  val_2 FROM table_2 WHERE val_2 = something))

0

Source: stackoverflow.com

Create table and insert values from another table

CREATE TABLE new_table AS
SELECT * 
FROM   old_table;

0

Source: stackoverflow.com

Similar codes

11 votes272 views1 answer
Oracle view ddl
SQL
1 vote294 views3 answers
How to reset id column in sql server
SQL
0 vote260 views1 answer
Mod in sql
SQL
0 vote262 views1 answer
Sql remove non numeric characters
SQL
2 votes211 views1 answer
Sql group by different columns
SQL
-1 vote254 views1 answer
How to check table exists or not in postgresql
SQL
0 vote285 views2 answers
Starts and end with vowel sql
SQL
0 vote249 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
2 votes263 views1 answer
Oracle sql concatenate results into string
SQL
0 vote249 views1 answer
Sql server update top n records
SQL

Share