Insert into and select

Question

Put a new row with insert into and then select

Answer 1

First learn SQL about insert

Answer 2

Done, now what?

Answer 3

There's two main ways to insert using select. The first can be used on existing tables and the second only works to create a table. I think the second one only works on temp tables but I havent confirmed.

INSERT INTO schema.table (col1, col2, ...)
SELECT col1, col2, ... FROM schema.other_table WHERE modifier_column = [value]

Or

SELECT col1, col2, ...
INTO #table
FROM schema.other_table
WHERE modifier_column = [value]