The Insert statement is used to add rows to a table. 

INSERT INTO <table_name> [(<column_name>[, ...)] {VALUES (expression [, ...]) | <select_statement>}

where:

table_name

is the name of the table in which you want to insert rows.

column_name

is optional and specifies an existing column.

expression

is the list of expressions that provides the values for the columns of the new record.

select_statement

is a query that returns values for each column_name value specified in the column list. Using a Select statement instead of a list of value expressions lets you select a set of rows from one table and insert it into another table using a single Insert statement. The SELECT statement is evaluated before any values are inserted. This query cannot be made on the table into which values are inserted.