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, etcfrom old_tablewhere col_a = 'some value" andcol_b = 'whatever'