Simply, you can use ‘Insert Into‘

ex:

Create Table newTable (id VarChar(10))

Insert Into newTable Select id from oldTable

Popularity: unranked [?]

Related interview questions

• Create dynamic query with dynamic joins
• Change date format mm/dd/yy to dd/mm/yy using query?
• Write query to get custom results
• Can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
• What is a base table?