Which of the following is the correct syntax for inserting the result of a query into another table in PostgreSQL?

Question

Answer

INSERT INTO table_2 (column_1, column_2, column_3)  
 SET column_1, column_2, column_3 =  
 SELECT column_1, column_2, column_3  
 FROM table_1  
 WHERE condition;

Answer

INSERT INTO table_2 (column_1, column_2, column_3)  
 SELECT column_1, column_2, column_3  
 FROM table_1  
 WHERE condition;

Answer

INSERT INTO table_2 (column_1, column_2, column_3)  
 INSERT SELECT column_1, column_2, column_3  
 FROM table_1  
 WHERE condition;

Answer

INSERT INTO table_2 (column_1, column_2, column_3)  
 SELECT FROM table_1  
 WHERE condition;

Crowdly

Which of the following is the correct syntax for inserting the result of a quer...

Want instant access to all verified answers on softserve.academy?