This INSERT SELECT statement copies orders from partitions 1 and 2 of the SLPPI orders table into the old_orders table, using the system-defined PARTITION column as a search condition and then deletes the copied orders from the orders table.
INSERT INTO old_orders SELECT * FROM orders WHERE orders.PARTITION IN (1,2) ;DELETE FROM orders WHERE orders.PARTITION IN (1,2);