Question:
Is it possible to select only certain records from a table and copy those records to a new table?
Answer:
The easiest way to move only certain records from one table to another is to use the insert command with a select statement:
ex. insert into new_table (col_a, col_b, col_c, etc)
select col_a,col_b,col_c, etc
from old_table
where
col_a = 'some value" and
col_b = 'whatever'
