1.3 Sub Query With Insert Statement
Sub queries also can be used with INSERT statements. The INSERT statement uses the data returned from the sub query to insert into another table. The selected data in the sub query can be modified with any of the character, date or number functions.
QUERY: - INSERT INTO table_name [ (column1 [, column2 ]) ]
SELECT [*|column1 [, column2 ]
FROM table1 [table2 ] [ WHERE VALUE OPERATOR ]
EXAMPLE: - INSERT INTO CUSTOMERS_BKP
SELECT * FROM CUSTOMERS
WHERE ID IN (SELECT ID FROM CUSTOMERS);
Last modified: Tuesday, 7 January 2020, 10:21 AM