Is there a way in DB2 to replace the entire table with just selected rows from the same table ?
REPLACE into tableName select * from tableName where col1='a';
(I can export the selected rows, delete the entire table and load/import again, but I want to avoid these steps and use a single query).
col1 col2 a 0 <-- replace all rows and replace with just col1 = 'a' a 1 <-- col1='a' b 2 c 3
Desired resultant table
col1 col2 a 0 a 1